Re: sql question

by example in DBMS Linter(Russia) :
 in trigger BEFORE INSERT replace incorrect date on NULL or
1 create table tst (i int, d date default NULL, c char(5), ².); 2 insert into tst(i, c, ²) values (1,ˆ111ˆ, ²) - insert correct data 3 update tst set d= to_date(ˆ01.08.2000ˆ,ˆdd.mm.yyyyˆ) where i=1 and c=ˆ111 ˆ and ².; value i, c ,² - from previos insert The correct date will replaced, incorrect date will NULL

Andreas Lommel ïèøåò â ñHHáùåíèè <194032820%398526ff.2057859_at_news.btx.dtag.de> ...
>Hi there. Ia want to load data ito a table-field. The data shall be a
>date. If the data is not a valid date there should be load value NULL
>in the field. How can I do this ?
>
Received on Tue Aug 01 2000 - 00:00:00 CDT