Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Date Format

Hi guys,

My date format in the database is something like 1,465,246,600.  What date format is this? How could I convert it into normal date format?

Thanks!

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That looks like a unix timestamp

Timestamp( Timestamp('1970-01-01 00:00:00.000') + 1465246600 /60/60/24)


talk is cheap, supply exceeds demand