Re: Date Format in Table Data Editor

I'm sure if I'm wrong someone will correct me but I think you're problem is down to the default date format that you have defined. If this is not mm/dd/yy then you will need to enter dates in the corrcet format, or if data entry will take place in the mm/dd/yy change the default dte format in init.ora.

Just one more thing though, still using 2 figure years???

Bryan

In article <MPG.15197cb88c1e4b8f989682_at_news.bellatlantic.net>, JimWilson
<nospam_at_nope.com> writes:
>I have a table with a date field. I can insert date via SQL*PLUS easily
>using:
>"insert into dd(f1) values(to_date('3/3/99','mm/dd/yy'));"
>
>This works fine until I try to enter a date in the Table Data Editor in
>the DBA Studio. It seems I must enter the date as
>"to_date('3/3/99','mm/dd/yy')". Is there a way to set up a trigger
 that
>will check the date (If entered as 3/3/99 in the Table Data Editor by a
>user) and then convert it into "to_date()" format before insert
 into the
>table?
>
>thanks
>Jim

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net