Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a Unix Time stamp ,
Unix Date: 1280867588 which has to be converted to PDT with time stamp, as 08/03/2010 06:33:08
Please Help.
I don't know nothing about "FROM_UNIXTIME(info_startdate)".
But the first expression doesn't do any Time Zone conversion. It converts unix datetime to QV datetime. And QV datetime time zone will be the same as unix datetime time zone. The question is what the unix time zone is. You should know it before any Time Zone conversion.
Something like this:
=timestamp((1280867588 /(24*60*60)) + (2 + date#('1/1/1970') - date#('1/1/1900')))
By using the above i get the value 8/3/2010 8:33:08 PM,
the actual value in GMT & PST for 1280867588
are below, could any one please let me know what is the time zone this syntax is converting to ? I need in PST/PDT
GMT Time: 2010-08-03 20:33:08
PST8PDT Time: 2010-08-03 13:33:08
Hi,
If your source data is a Unix TimeStamp you can use this in the SQL part of the LOAD statement:
(the date I was trying to convert was info_startdate)
SQL SELECT *, FROM_UNIXTIME(info_startdate) as Info_Start_Date
You are really beginner. Try to read the Help before ask. Here is your function:
=ConvertToLocalTime(
timestamp((1280867588 /(24*60*60)) + (2 + date#('1/1/1970') - date#('1/1/1900')))
, 'GMT-08:00')
Thank you very much for the reply , Could anybody please tell me what is the Time Zone the unix time is being converted into when using :
timestamp((start_time /(24*60*60)) + (2 + date#('1/1/1970') - date#('1/1/1900')))
or
FROM_UNIXTIME(info_startdate)
I don't know nothing about "FROM_UNIXTIME(info_startdate)".
But the first expression doesn't do any Time Zone conversion. It converts unix datetime to QV datetime. And QV datetime time zone will be the same as unix datetime time zone. The question is what the unix time zone is. You should know it before any Time Zone conversion.