Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on the date after '31-DEC-9999' in Oracle
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,1Received on Tue May 24 2005 - 12:41:19 CDT