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:47:10 -0700
Message-ID: <1116956830.081613.296350@g49g2000cwa.googlegroups.com>

select enddate
from pc_mike
where trunc(enddate) > trunc(to_date('31-DEC-9999','DD-MON-YYYY')); ENDDATE

01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00
01-JAN-00

Received on Tue May 24 2005 - 12:47:10 CDT

This message: [ Message body ]
Next message: Mark C. Stock: "Re: Question on the date after '31-DEC-9999' in Oracle"
Previous message: Mike: "Re: Question on the date after '31-DEC-9999' in Oracle"
In reply to: Rauf Sarwar: "Re: Question on the date after '31-DEC-9999' in Oracle"
Next in thread: Mark C. Stock: "Re: Question on the date after '31-DEC-9999' in Oracle"
Reply: Mark C. Stock: "Re: Question on the date after '31-DEC-9999' in Oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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