Home » SQL & PL/SQL » SQL & PL/SQL » Convert number in milliseconds to date
Convert number in milliseconds to date [message #522] Mon, 18 February 2002 00:20 Go to next message
Rita Nzenwa
Messages: 1
Registered: February 2002
Junior Member
I've got an application that has a timestamp field with dates as for example, 1011032085465.

How do I convert these to Oracle dates?

Report message to a moderator

Re: Convert number in milliseconds to date [message #524 is a reply to message #522] Mon, 18 February 2002 02:02 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

oracle internally stores date in number of millisecond elapsed since january 1,4712 BC. but what the 1011032085465milisecond stands for, in your case.

cheers
pratap

Report message to a moderator

Previous Topic: ORA-00604 & ORA-01000 Error , Help Please!
Next Topic: import and export in text form
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 15:33:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.