Re: DATE

From: Vipul Lakhani <vlakhani_at_cromwellmedia.co.uk>
Date: 2000/07/13
Message-ID: <8kk7q6$geu$1@taliesin2.netcom.net.uk>#1/1

Insert into table_name_here (my_date_col) Values ( to_date('25/12/99','DD/MM/RR') );

Will do the trick

NOTE : use the format mask RR instead of YY (Y2k issues involved here .. see oracle manual for more format masks and further notes )

Sandy <daleelaNOdaSPAM_at_usa.net.invalid> wrote in message news:0df81cc0.749c2e3e_at_usw-ex0109-068.remarq.com...
> Hi,
>
> I would like to know when you declare a date in the date
> format is it DD-MON-YY ? if it is like this, I would like
> to insert a date like this DD/MM/YY in a table where this
> date is declared like DATE.
>
>
> thanks
>
> sandy
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Thu Jul 13 2000 - 00:00:00 CDT