Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a timestamp field in my source data with 10 million approx distinct data.
There is only one straight table where i need to display this timestamp value in my qvw.
Now we have read in community that to optimize the performance of the qvw application we should not use the timestamp instead use the date .
Could someone please suggest a way to use this timestamp field with more
Note: i am using the date of the time stamp to link with my calendar and using this timestamp value in only one straight table
Break the timestamp into two separate fields -- Date and Time, using script such as this:
date(floor(mytimestamp)) as MyDate,
time(frac(mytimestamp) as MyTime
-Rob
Break the timestamp into two separate fields -- Date and Time, using script such as this:
date(floor(mytimestamp)) as MyDate,
time(frac(mytimestamp) as MyTime
-Rob