Subject Re: Help - Data conversion
Author acamargo_alc
--- In ib-support@y..., Lucas Franzen <luc@r...> wrote:
Luc,
works

tks.......

>
> Alessandro,
>
>
> > ALTER TRIGGER AUX_2 ACTIVE before insert POSITION 0
> > AS
> >
> > begin
> > if ( new.dt_creation ='01/01/00' ) then
> > new.dt_creation = '';
>
> new.dt_creation = NULL;
>
> But I'm always a little afraid of solutions, attaching a certain
meaning
> to a certain date ...
>
>
> Luc.