RE: a how can I do this in Informix question
Why not leave "insdate as datatype DATE and set DBDATE=4YMD when you want to
view it?
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Obnoxio The Clown" <obnoxio@serendipita.com>
>To: informix-list@iiug.org
>Subject: RE: a how can I do this in Informix question
>Date: Fri, 28 Oct 2005 17:18:05 +0100 (BST)
>
> >> > Hello,
> >> >
> >> > I have a problem in Informix that I need to solve.
> >> >
> >> > I have table
> >> >
> >> > Table ABC
> >> > {
> >> > Field1 integer,
> >> > Field2 char(5),
> >> > Insdate integer
> >> > }
> >> >
> >> > What I want now is when an insert occurs on this table on the fields
> >> > (Field1 and Field2) that afterwards the fields Insdate is filled
> > with
> >> > the date of today but stored as a number in the format YYYYMMDD.
>
>Why? Why not just keep the fricking date?
>
> >> > Example:
> >> >
> >> > Insert into ABC (Field1, Field2)
> >> > values (1, "Wim");> >> >
> >> > then should the query
> >> >
> >> > Select * from ABC;> >> >
> >> > return:
> >> >
> >> > Field1 Field2 Insdate
> >> > 1 Wim 20051027
> >> >
> >> > My collegue found how to do it in Oracle and now I want to prove it
> > also
> >>
> >> > can be done in Informix. I hope. Else me and my big mouth :-)
> >> >
> >> > So help me please.
> >> >
> >> > Thanks,
> >> >
> >> > Wim
> >> sending to informix-list
> > sending to informix-list
> >
>
>
>--
>Bye now,
>Obnoxio
>
>"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule"
> - Coluche
>
>"You are an index and a prologue to the history of lust and foul thoughts."
> - William Shakespeare
>sending to informix-list
sending to informix-list