Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 converting date from unix ticks format

Author  Topic 

npopovych
Starting Member

1 Post

Posted - 2013-10-15 : 05:52:26
I have the date in unix ticks format (stored in SQL-server as NUMERIC (32,0)) and which looks as 1498798800000. I need to convert it into normal DATETIME format for inserting into HANA.

Could you please advise what function can be used?

npopovych

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2013-10-15 : 08:22:43
SELECT DATEADD(ss, UnixTime, '1970-01-01')
FROM table

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page
   

- Advertisement -