Home » SQL & PL/SQL » SQL & PL/SQL » DateTime Format
DateTime Format [message #19487] Thu, 21 March 2002 10:25 Go to next message
James
Messages: 120
Registered: June 2000
Senior Member
Is there a way in Oracle 8i to display milliseconds in the time?

I wasn't able to find this in any Oracle documentation and I need to distinguish between records that Oracle shows were written at the same second. I used this format and it brings it down to the second. I added in the number of seconds since Midnight, but that turned out to be the same for two rows: to_char(eh.time, 'MM/DD/YYYY HH:MI:SS:SSSSS AM')

Report message to a moderator

Re: DateTime Format [message #19488 is a reply to message #19487] Thu, 21 March 2002 10:42 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
No, the DATE datatype only includes resolution down to seconds. If you need finer resolution, you can create a Java stored function to return a timestamp that includes milliseconds. See:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:341817437103

Report message to a moderator

Re: DateTime Format [message #19505 is a reply to message #19487] Fri, 22 March 2002 04:52 Go to previous message
Alex Mazur
Messages: 17
Registered: March 2002
Junior Member
Take a look on dbms_utility.get_time function. May be
it can help you.

Report message to a moderator

Previous Topic: help in simple sql statement
Next Topic: Deleting Dups
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 05:45:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.