Re: Dates for 21st Century?

Another option besides using the year mask YYYY, you could use the year mask RR which gives you 1950 through 2049.

scott moyer
dmoyer_at_gpu.com (home)
dsmoyer_at_enter.net (home)

In <46s160$f91_at_dpcgate.sannet.gov>, dpcauh_at_dev25t2.sannet.gov (Jack Hurlbut) writes:
>I've just started using Oracle and am having problems with dates after
>1999. I'm writing a data entry form using Arc (a GIS Geographic
>Information System) as the client. We will be processing zoning changes
>where the change will be dependant upon certain conditions being met by
>a future date. In some cases that date has been as far as 6 years in the
>future. This means that the ability to enter dates from the year 2000
>and later is critical. How do I get around the DD/MMM/YY format for
>input? Here are examples:
>
>insert into test_table (ENG_DATE) values ('1-JAN-2001')
>ORA-01830: date format picture ends before converting entire input str
>insert into test_table (ENG_DATE) values ('1-JAN-00')
>
>When I do a select on the table the date is
> ENG_DATE '1900-01-01 00:00:00 '
>
> I know there must be a solution. Any help will be greatly appreciated.
>
> Jack Hurlbut
> dpcauh_at_dev25t2.sannet.gov
>
>
Received on Mon Oct 30 1995 - 00:00:00 CET