Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Date Format: Mystery

Re: Date Format: Mystery

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Thu, 29 Jan 2004 16:29:28 -0800
Message-ID: <F001.005DE60A.20040129162928@fatcity.com>



Rajesh,

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: Rajesh.Pillai@nordstrom.com

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: ListGuru@fatcity.com (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.    +31 (0) 182 640 428
fax     +31 (0) 182 640 429
mobile  +31 (0) 653 911 950
e-mail info.dbalert@xs4all.nl



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Carel-Jan Engel
  INET: cjpengel.dbalert_at_xs4all.nl

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: ListGuru_at_fatcity.com (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).
Received on Thu Jan 29 2004 - 18:29:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US