Re: Dates for 21st Century?

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
>
>

Jack,

All you need to do is to use a different date mask than the default. Modify the values clause like this:

values ( to_date ( '01-JAN-2001', 'DD-MMM-YYYY' ) )

Rich Woods
Oracle Worldwide Customer Support Received on Sat Oct 28 1995 - 00:00:00 CET