Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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

Re: Date Format

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
Community Browser