Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
date(date(floor(RECEIVEDDATE/1000/60/60/24)) +date('1970-01-01')) As ReceivedDate,