I want to Convert "632689920000000000" Unixtime to Timestamp sql.
I already tried
dateadd(s,632689920000000000,'19700101')
and
DATEADD(SECOND, 632689920000000000 / 1000, '19691231 20:00')
but it returns irrelevent data in each data!!!
Asked
Active
Viewed 56 times
0
Ganesh Pitchai
- 75
- 1
- 5
-
2What [tag:rdbms] are you using? – Mureinik Apr 04 '18 at 17:51
-
it is amazon redshift and data retreived from Mongodb – Ganesh Pitchai Apr 04 '18 at 17:54
-
What exact timestamp would you expect? If you divide by 10^9 it would result in `632689920` = `1990-01-18 20:12:00` – dnoeth Apr 04 '18 at 17:57
-
Is this what you are looking for [How to convert epoch to datetime](https://stackoverflow.com/questions/39815425/how-to-convert-epoch-to-datetime-redshift) – kc2018 Apr 04 '18 at 18:02
-
it is the correct date for this particular data? – Ganesh Pitchai Apr 04 '18 at 18:03
-
thanks https://stackoverflow.com/questions/39815425/how-to-convert-epoch-to-datetime-redshift solved the issue – Ganesh Pitchai Apr 09 '18 at 17:32