Convert unix date to utc

41 Views Asked by At

I have table with list of date, but date in unix format. I need to convert unix time to utc. The function FROM_UNIXTIME is not clear for me. Cause when i try to use it, i have error: "FROM_UNIXTIME" is not recognized built-in function name

I create sql request: select name, dateadd(hour,-5,(dateadd(SS,CONVERT(int,substring(call_connect_time,4,10)).'19700101'))) as call_time from db

and i have error: argument data type datetime is invalid for argument 1 of substring function.

Do you have any idea what should i do?

0

There are 0 best solutions below