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.
| 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- LumbagoMy blog-> http://thefirstsql.com |
 |
|
|
|
|
|
converting date from unix ticks format