Qlik Sense timestamp accuracy

[AnkitMadhukar]

Hi Everyone ,

Is there a format available in Qlik Sense to store timestamps till micro-seconds accuracy.
Right now the format I am using is 'MM/DD/YYYY hh:mm:ss.fff'


Thanks,
Ankit 

[QFabian · Accepted solution]

Hi @AnkitMadhukar , date fields are saved as numbers with decimals, so if the field has date and hour with minutes and more, its going to be a number with several decimals :

check this articles i fund right here in qommunity :

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Timestampconversion-Timestamp-format-wi...

https://community.qlik.com/t5/New-to-QlikView/converting-milliseconds-to-Date-Time-format/m-p/120012...

[QFabian]

the second one talks about using environmental variable TimestampFormat

[simonaubert · Accepted solution]

Hello,

As I mention here : https://community.qlik.com/t5/Ideas/Qlik-Timestamp-precision-go-to-the-nanesecond-equivalent-to-DB/i...

QS store millisecond TS only. If you want to go further, you have to store it in text. The idea above details the workaround but suggests Qlik to update their TS precision to nanosecond.

Best regards,

Simon

[AnkitMadhukar]

Thanks @simonaubert  , 
For now I am going to use milliseconds precision.

[AnkitMadhukar]

Thanks @QFabian ,

For now I am going to use milliseconds precision.
Will switch to decimals if it becomes mandatory later on