SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 09:28 AM
| ||||
| ||||
 RE: a how can I do this in Informix question >> > 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      |
|
04-20-2008, 09:28 AM
| |||
| |||
| Re: a how can I do this in Informix question Because we have users that can use any tool to connect via ODBC and it is not alwys possible to set DBDATE this way. And yes they are lazy. They want to learn as less as possible. Surely not the different date formats of Oracle, Informix, Teradata and MS SQLserver, which we all have. Obnoxio The Clown wrote: >>>>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 >> > > > |
Linear Mode
