Carel-Jan,
This explanation helps. Thanks a
lot.
Could you also answer if displaying
centiseconds or milliseconds or 1/10th of a second in oracle is possible or
not
Thanks,
Rajesh
-----Original Message-----Rajesh,
From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 4:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Date Format: Mystery
A look into the docs might help you:
In date-format SS means seconds as of the seconds 00-59 in a minute.
SSSSS means seconds since midnight, thus 0 - 86399
Compiling the statement the longest part is recocnized first.
So:
SS give 06 in your first example.
SSSS gives 20, but twice: 2020
SSSSSS consists of the SSSSS part, followed by an unrecocnized single S: error
SSSSSSSS consists of SSSSS, followed by SS, followed by an unrecognized S: error
SSSSSSSSSS is SSSSS SSSSS, so the result is 46439 46439.
Regards, Carel-Jan
At 10:29 PM 1/29/2004, you wrote:
Hi All,See the following -
1) select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS AM') from dual;
result = 2004-01-29 12:52:06 PM
2) select to_char(sysdate,'YYYY-MM-DD HH24:MI:SSSS AM') from dual;
result = 2004-01-29 12:52:2020 PM
3) select to_char(sysdate,'YYYY-MM-DD HH24:MI:SSSSSS AM') from dual;
ORA-01821: date format not recognized
4) select to_char(sysdate,'YYYY-MM-DD HH24:MI:SSSSSSSS AM') from dual;
ORA-01821: date format not recognized
5) select to_char(sysdate,'YYYY-MM-DD HH24:MI:SSSSSSSSSS AM') from dual;
result = 2004-01-29 12:53:4643946439 PM
What does it mean? If I want to see the 10th part of the second or 100th part of the second, Is it poosible?
I would appreciate all your hints.
Thanks,
Rajesh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Pillai, Rajesh
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
If you think education is expensive, try ignorance. (Derek Bok)
===
DBA!ert, Independent Oracle Consultancy
Kastanjelaan 61C
2743 BX Waddinxveen
The Netherlands
tel.
fax
mobile
e-mail [EMAIL PROTECTED]