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

Home -> Community -> Usenet -> c.d.o.server -> Re: Question on the date after '31-DEC-9999' in Oracle

Re: Question on the date after '31-DEC-9999' in Oracle

From: Mike <michaelnazareth_at_gmail.com>
Date: 24 May 2005 10:41:19 -0700
Message-ID: <1116956479.687131.15480@o13g2000cwo.googlegroups.com>


select dump(enddate) from pc_mike where enddate > '31-DEC-9999';

DUMP(ENDDATE)


Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Typ=12 Len=7: 200,100,1,1,1,1,1
Received on Tue May 24 2005 - 12:41:19 CDT

Original text of this message

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