Home » RDBMS Server » Server Administration » How to get milliseconds from the time
How to get milliseconds from the time [message #370004] Mon, 27 November 2000 17:27 Go to next message
Preeti
Messages: 14
Registered: November 2000
Junior Member
Hi,

I need to get the milliseconds of the sysdate. Could someone please tell me how I can do this.
Thanks!
Preeti

Report message to a moderator

Re: How to get milliseconds from the time [message #370019 is a reply to message #370004] Thu, 30 November 2000 02:12 Go to previous messageGo to next message
Tittom
Messages: 15
Registered: November 2000
Junior Member
Unfortunately, this is impossible (I read that on the oracle forum of the oracle website).

If you need this to build a unique key, you can concatenate the time with a sequence starting at 100 and ending at 999, which implies that you won't generate more than 900 rows in a second.

Regards,
Tittom

Report message to a moderator

Re: How to get milliseconds from the time [message #370020 is a reply to message #370004] Thu, 30 November 2000 03:40 Go to previous messageGo to next message
LB
Messages: 13
Registered: September 2000
Junior Member
Maybe I'm missing something here but I tried the following
SELECT TO_CHAR(SYSDATE,'SS') * 1000 FROM DUAL
and got a result.

Report message to a moderator

Re: How to get milliseconds from the time [message #370025 is a reply to message #370004] Thu, 30 November 2000 11:44 Go to previous message
Preeti
Messages: 14
Registered: November 2000
Junior Member
Thanks...I need the values to be unique. WAs thinking of appending a seq value too.

Report message to a moderator

Previous Topic: Remove Directories in Oracle8i Trigger
Next Topic: Re: Oracle 8i Error Message
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 23:04:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.