Home » SQL & PL/SQL » SQL & PL/SQL » capturing milliseconds in oracle8
capturing milliseconds in oracle8 [message #268083] Mon, 17 September 2007 08:39 Go to next message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Hi Gurus,

My production database is using oracle 8.

I want to capture the sysdate with milliseconds in a table.

Pls advice.

Regards
Murali
Re: capturing milliseconds in oracle8 [message #268088 is a reply to message #268083] Mon, 17 September 2007 08:51 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
You can use a timestamp datatype which will store the milliseconds or do some date arithmetic on date datatypes.

Have a look:

http://www.dba-oracle.com/t_timespamp_math_elapsed_times.htm

Re: capturing milliseconds in oracle8 [message #268089 is a reply to message #268088] Mon, 17 September 2007 08:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Wasn't timestamp introduced in release 9 ?
Re: capturing milliseconds in oracle8 [message #268091 is a reply to message #268089] Mon, 17 September 2007 08:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it was introduced in 9i.
In Oracle 8.0 you can't do anything but create an external procedure.
In Oracle 8.1 you can create a java class that can handle millisecond.

Regards
Michel
Re: capturing milliseconds in oracle8 [message #268107 is a reply to message #268091] Mon, 17 September 2007 09:21 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you can get away with 100ths of a second, then you can use DBMS_UTILITY
Re: capturing milliseconds in oracle8 [message #268126 is a reply to message #268107] Mon, 17 September 2007 11:26 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Well, dbms_utility.get_time is only useful if you want to get interval as you don't know the origin of the epoch and it can (and will) be different after each instance startup.

Regards
Michel
Previous Topic: Function to return Nested Table
Next Topic: Unicode support in the where clause of DELETE statement
Goto Forum:
  


Current Time: Thu Dec 08 04:08:05 CST 2016

Total time taken to generate the page: 0.06749 seconds