Boundary of date in Oracle?
From: (wrong string) ªü´ö Thenardier <Thenardier_at_POBoxes.com>
Date: 1997/11/19
Message-ID: <34730089.4311903_at_news.netvigator.com>#1/1
Date: 1997/11/19
Message-ID: <34730089.4311903_at_news.netvigator.com>#1/1
[Quoted] [Quoted] What is the boundary of date that Oracle can handle?
[Quoted] [Quoted] Another question is, the year in a date that displays in SQL/Plus is a 2-digit one. When the 2 digits are '01', how would Oracle treat that '01' in YYYY format? '1901', or '2001'? Then what should i do if i want to force Oracle to convert it into a '20YY' date? And what if i want it a '19YY' one instead?
Thanx!
Thenard Received on Wed Nov 19 1997 - 00:00:00 CET