Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Date Format in Table Data Editor
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 - 12:06:37 CST
![]() |
![]() |