Number to Date in Oracle sql

Asked Jan 14 '15 at 09:43

Active Jan 14 '15 at 09:47

Viewed 50 times

I have a number column where date is stored as epoch unix timestamp in millisec like (1406851200000). How can i use this value to compare the date against another column where date is stored in TIMESTAMP(6) format.

I searched a lot. But not able to figure out the same.

edited Jan 14 '15 at 09:47

asked Jan 14 '15 at 09:43

Andromeda

12,659
20
77
103

2

http://stackoverflow.com/q/13914579/330315 – Jan 14 '15 at 09:48
2

http://stackoverflow.com/a/26711372/3989608 – Lalit Kumar B Jan 14 '15 at 09:49

Number to Date in Oracle sql

0 Answers0