Oops...

Igor Neyman, OCP DBA
[EMAIL PROTECTED]



-----Original Message-----
Peter Gram
Sent: Friday, January 23, 2004 2:54 PM
To: Multiple recipients of list ORACLE-L

Igor

Sorry but Oracle uses 7 bytes for a date

century (1 byte)
year (1 byte)
month (1 byte)
day (1 byte)
hour (1 byte)
minute (1 byte)
second (1 byte)

SQL> desc d
 Name                                      Null?    Type
 ----------------------------------------- -------- 
----------------------------
 D                                                  DATE

SQL> col dump format a40
SQL> select to_char(d, 'dd mon rrrr hh24:mi:ss'), dump(d) dump from d;

TO_CHAR(D,'DDMONRRRR DUMP
-------------------- ----------------------------------------
05 may 0001 15:30:45 Typ=12 Len=7: 100,101,5,5,16,31,46
05 may 0100 15:30:45 Typ=12 Len=7: 101,100,5,5,16,31,46
05 may 0500 15:30:45 Typ=12 Len=7: 105,100,5,5,16,31,46
05 may 1000 15:30:45 Typ=12 Len=7: 110,100,5,5,16,31,46
05 may 1500 15:30:45 Typ=12 Len=7: 115,100,5,5,16,31,46
05 may 1999 15:30:45 Typ=12 Len=7: 119,199,5,5,16,31,46
05 may 2000 15:30:45 Typ=12 Len=7: 120,100,5,5,16,31,46
05 may 2100 15:30:45 Typ=12 Len=7: 121,100,5,5,16,31,46
05 may 2500 15:30:45 Typ=12 Len=7: 125,100,5,5,16,31,46
05 may 2600 15:30:45 Typ=12 Len=7: 126,100,5,5,16,31,46
05 may 2900 15:30:45 Typ=12 Len=7: 129,100,5,5,16,31,46
05 may 3000 15:30:45 Typ=12 Len=7: 130,100,5,5,16,31,46

12 rows selected.

/peter

Igor Neyman wrote:

>You gather it wrong :)
>Oracle stores date in 8 bytes, one for each: year, month, day, hour,
>min, ... etc.
>
>Igor Neyman, OCP DBA
>[EMAIL PROTECTED]
>
>
>
>-----Original Message-----
>Droogendyk, Harry
>Sent: Friday, January 23, 2004 12:40 PM
>To: Multiple recipients of list ORACLE-L
>
>Folks:
>
>>From what I gather, Oracle stores dates as the number of elapsed days
>since
>Jan 1, 1968.  When I query a column of type 'DATE', it returns me the
>default format, dd-mon-yy.  I know I can use
>to_char(date_col,'YYYYMMDD')
>etc... to define many output formats.
>
>What can I do to get the raw internal value of the date?  i.e. today is
>13172.
>
>Thanks. 
>  
>

-- 

Best regards/Venlig hilsen

/*Peter Gram*/ <mailto:[EMAIL PROTECTED]>

Miracle A/S <http://www.miracleas.dk/>
Kratvej 2
DK - 2760 Måløv

Cell:  (+45) 2527 7107
Phone: (+45) 4466 8855
Fax:   (+45) 4466 8856
Home:  (+45) 3874 5696
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

SQL Server Master Class 8-10 Marts,
Database Forum 28-30 October
Master Class 17-19 Januar 2005.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter Gram
  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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Igor Neyman
  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).

Reply via email to