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

Home -> Community -> Usenet -> c.d.o.misc -> Boundary of date in Oracle?

Boundary of date in Oracle?

From: ªü´ö Thenardier <Thenardier_at_POBoxes.com>
Date: 1997/11/19
Message-ID: <34730089.4311903@news.netvigator.com>#1/1 









What is the boundary of date that Oracle can handle?



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 CST












Original text of this message













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