2000 AD - Oracle Date Format

From: Erik Lindquist <elindquist_at_logicon.com>
Date: 1996/03/22
Message-ID: <31532502.1BC1_at_logicon.com>#1/1

Just wondering... Currently the default date format for Oracle is DD-MON-YY. What will happen in the year 2000 if I query the database like this:

SELECT...
FROM ...
WHERE DATE_COLUMN = '22-MAR-96' Is this date going to evaluate to the year 1996 or 2096?

Anyone know? Thanks.

-Erik. elindquist_at_logicon.com Received on Fri Mar 22 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Ashwin Vassant Shirvaikar : "US-NYC- Powerbuilder/Oracle project, good rate"
Previous message: Mark: "DB Backup on HP-UX 10.01"
Next in thread: Joseph Y. Suh: "Re: 2000 AD - Oracle Date Format"
Reply: Thomas J Kyte: "Re: 2000 AD - Oracle Date Format"
Reply: Charles Wolfe: "Re: 2000 AD - Oracle Date Format"
Reply: Claude Tucker: "Re: 2000 AD - Oracle Date Format"
Reply: Joseph Y. Suh: "Re: 2000 AD - Oracle Date Format"

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

Original text of this message