Solved: Datetime format - Qlik Community

Report Inappropriate Content · ‎2014-08-15

In my Load script,

(Modified_Date, 'YYYY-MM-DD hh:mm:ss') as Modified_Date

gets me the value 2014-08-12 16:03:31

but I need 2014-08-12 16:03:31.643

I would appreciate help...

Thanks

Gysbert_Wassenaar · ‎2014-08-15

Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2014-08-15

Original field is a datetime/timestamp: date(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

Original field is a text value: tetime/timestamp: date#(Modified_Date, 'YYYY-MM-DD hh:mm:ss.fff') as Modified_Date

talk is cheap, supply exceeds demand

PrashantSangle · ‎2014-08-15

Hi,

try with Timestamp() and Timestamp#()

Like,

Timestamp(DateField, 'YYYY-MM-DD hh:mm:ss.fff')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Datetime format

Related Topics