Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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

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