How to convert Unix Time Stamp

[#1]

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...

[engishfaque]

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]

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