Re: year 2000 - Maybe a stupid question

Not konwing the details, if you are in PL/SQL, SQL or SQL*Plus, all you need to do is something like:

update tablename
set date1 = to_date('01.01.2000','dd.mm.yyyy') where .........

Good luck !!!

suresh.bhat_at_mitchell-energy.com

Birgit Merschmann <B.Merschmann_at_invent.de> wrote in article <35b49e5a.0_at_news.teuto.de>...
> Hi,
>
> I'm working with Delphi 3 C/S and currently with Oracle 7.3.2.3.1
> (later with Oracle 8) , the BDE is the latest version (4.51).
> Now my problem: I can't insert a date with 4 characters; for example:
> 01.01. 2000. I know that my date format is not correct and that Oracle
> supports the year 2000 but I'm too stupid to find where I have to change
it
> and what I have to do.
> Can anybody help?
>
> Thanks in advance,
>
> Birgit
>
> B.Merschmann_at_invent.de
>
>
>
Received on Tue Jul 21 1998 - 10:05:59 CDT