Home » SQL & PL/SQL » SQL & PL/SQL » Time function in Oracle
Time function in Oracle [message #20397] Mon, 20 May 2002 20:25 Go to next message
Denna
Messages: 1
Registered: May 2002
Junior Member
I need to use the time function in Oracle that include mili second. Ex. Select to_char(sysdate,'yyyy-mm-dd H24:MI:SS:??'). Could anyone help me ???
Thanks in advance

Report message to a moderator

Re: Time function in Oracle [message #20400 is a reply to message #20397] Tue, 21 May 2002 02:25 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Miliseconds aren't possible in SQL - PL/SQL. You could, however create a Java Stored Procedure to retrieve the time in miliseconds.

MHE

Report message to a moderator

Previous Topic: update exception handling
Next Topic: Re: SQL Count Statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 20:32:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.