Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: converting milliseconds to Oracle DATE
<laredotornado_at_zipmail.com> wrote in message
news:1148068468.365556.217170_at_u72g2000cwu.googlegroups.com...
> Hello,
>
> Using Oracle 9i on Solaris, how do I convert a numeric data column
> (which represents milliseconds passed since Jan, 1, 1970 midnight) to a
> DATE column?
>
> Thanks, - Dave
>
select timestamp '1970-01-01 00:00:00.00 +00:00' +
numtodsinterval(to_number(:unixstamp,'9999999999D999','NLS_NUMERIC_CHARACTERS=''.
'''),'SECOND')) at local
Received on Mon May 22 2006 - 03:46:44 CDT