Convert Unix timestamp

srini.dw · Post by **srini.dw** » Wed Dec 23, 2009 6:33 am

Hi,

Source is SQL Server, target is Teradata.

Source column is Unix timestamp. 1065531990.

Please let me know how to convert date and time separately.

Searched the forum but could not get exact syntax.

Thank you,

chulett · Post by **chulett** » Wed Dec 23, 2009 8:18 am

Start someplace like here:

http://www.unixtimestamp.com/index.php

priyadarshikunal · Post by **priyadarshikunal** » Wed Dec 23, 2009 9:33 am

and the syntax will be something like

Code: Select all

TimestampFromSecondsSince(<unix timestamp column>, StringToTimestamp("1970-01-01 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss"))

1065531990 gives the result
2003-10-07 13:06:30 (7th oct 2003 13:06:30)

while the link posted by Craig calculates it to
10 / 07 / 03 @ 8:06:30am (7th oct 2003 8:06:30)

since its just a offset from 1st jan 1970 probably that site is converting it to -5 hrs.

srini.dw · Post by **srini.dw** » Wed Dec 23, 2009 10:12 pm

Thank you, Priyadarshi Kunal.

Iam able to get the expected result with the conversation give by you.