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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to convert Unix Time Stamp

Hi,

I have a database with one of the fields "Receiveddata" in format like:

1014937200

1025521200

etc...

In Epoch Converter we have...

1025521200        

MT: Thu, 28 Feb 2002 23:00:00 GMT
Your time zone: ‎01‎.‎03‎.‎2002‎ ‎1‎:‎00‎:‎00 GMT+2:00

help me please, to convert to the Human date...

"ODBC CONNECT TO ...............................

LOAD RECEIVEDDATE,
TYPE,
Date('RECEIVEDDATE','MM/DD/YYYY') as RECEIVEDDATE1;              (is not working...)

SQL SELECT RECEIVEDDATE,
TYPE,

............"

is not working...

12 Replies
engishfaque
Specialist III
Specialist III

Dear Viorel,

Please check,

Unix timestamp from a string to date

DB2 time converter

Kind regards,

Ishfaque Ahmed

MarcoWedel

Date settings

UNIX DATE to Qlikview DATE

Maybe helpful

Regards

Marco

diwaskarki
Creator II
Creator II

date(date(floor(RECEIVEDDATE/1000/60/60/24)) +date('1970-01-01')) As ReceivedDate,