OraFAQ Forum: SQL & PL/SQL » Re: Oracle sysdate to return milliseconds

Home » SQL & PL/SQL » SQL & PL/SQL » Re: Oracle sysdate to return milliseconds

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Oracle sysdate to return milliseconds [message #18475]

Fri, 01 February 2002 01:09

Shaik Khaleel
Messages: 5
Registered: February 2002

Junior Member

Select to_char(sysdate,'sssss') from dyal

Report message to a moderator

Re: Oracle sysdate to return milliseconds [message #18639 is a reply to message #18475]

Fri, 08 February 2002 03:22

Brandon
Messages: 9
Registered: November 1999

Junior Member

Correction:

Select to_char(sysdate,'sssss') from dual

Report message to a moderator

Re: Oracle sysdate to return milliseconds [message #18641 is a reply to message #18475]

Fri, 08 February 2002 04:08

MS
Messages: 11
Registered: September 2000

Junior Member

>> Select to_char(sysdate,'sssss') from dual

Hey !

But this thing does return amount of seconds from
midnight , not milliseconds

Anyone knows the right solution

Report message to a moderator

Re: Oracle sysdate to return milliseconds [message #19104 is a reply to message #18475]

Thu, 28 February 2002 06:28

qwer
Messages: 1
Registered: February 2002

Junior Member

all that does is get the seconds since midnight, as the previous poster mentioned ('sssss')

Report message to a moderator

Previous Topic:	VERY URGENT PLEASE HELP
Next Topic:	not a single group function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 22:25:25 CDT 2024