Date Format in Table Data Editor

From: JimWilson <nospam_at_nope.com>
Date: Wed, 14 Mar 2001 18:06:58 GMT
Message-ID: <MPG.15197d0b78d96404989684_at_news.bellatlantic.net>


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 Received on Wed Mar 14 2001 - 19:06:58 CET

Original text of this message