Qlik - 057: How to get Date and Time from a TimeStamp?

In this video we will see, how to we can get Date and Time from a TimeStamp field
1) How to check a field is interpreted as TimeStamp or not? (00:00:01 – 00:02:40)
2) How to use Floor, Ceil and Frac? (00:02:41 – 00:04:15)
3) How to use Floor and Frac on TimeStamp field at front end (00:04:16 – 00:07:05)
4) How to use Floor and Frac on TimeStamp at back end (00:07-06 – 00:07:58)
5) How to Interpret TimeStamp field and use Floor and Frac on it (00:07:59 – 00:11:14)

If you want to read on Floor() function from Qlik Help

If you want to read on Ceil() function from Qlik Help

If you want to read on Frac() function from Qlik Help

Check Interpretation and Formatting functions videos

You can also find me on

#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #sql #sqlconnection #sqldataconnection #forloop #foreachloop #qvd #createqvd #aggregation #Total #MappingLoad #ApplyMap #MapUsing #NestedApplyMap #numberformat #incremental #incrementalload #deltaload #insertonlyincrementalload #insertandupateincrementalload #insertupdateanddeleteincrementalload #Date #DateHash #Intrepretation #Formatting #interrecord #peek #previous #above #below #TimeStamp

[nithinp]

Hi Manish can you do a video on rollingsum and and rolling averages

[hasanmougharbel]

Hey there, glad to meet again.
I learned about timestamp as a date data type.
My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen?
Thanks for taking care of this.

[anu]

Hi,
Does converting date field to floor/num helps in improving the chart performance when we have 30M+ records(complex measures). And it is converted to monthyear at chart dimension.