OraFAQ Forum: Server Administration » NLS_DATE

Home » RDBMS Server » Server Administration » NLS_DATE_FORMAT

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

NLS_DATE_FORMAT [message #154210]

Fri, 06 January 2006 04:36

neila
Messages: 1
Registered: January 2006

Junior Member

Hi!
what is the format of NLS_DATE_FORMAT if I want to dispaly
the fractional second,( HH24:MI:SS:....)
Best,
Neila

Report message to a moderator

Re: NLS_DATE_FORMAT [message #154237 is a reply to message #154210]

Fri, 06 January 2006 06:04

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

The DATE type doesn't record fractional seconds - use TIMESTAMP instead:

SQL> select systimestamp from dual;

SYSTIMESTAMP
----------------------------------------------------------------
06-JAN-06 02.01.30.462818 PM +02:00

Report message to a moderator

Previous Topic:	Can not open pipe for DB_STATUS
Next Topic:	SOS:HELP,HELP,ORA-00600: ?: [kcratr1_lastbwr], [], [], [], [], [], [], [],HURRY!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 16:54:53 CST 2025