Re: Informix datetime type

Zhiyong Li wrote: > > Anyone can give a good description about Informix datetime type. > Specifically, > I have a question about datetime values retrieved from database when the > value is Null. Even I write a null value to the datetime column, when I > retrieve it. The > return value is not null. Anyone knows are there anyway I can enforce this > behavior? > > What I need is that if I update a row with a NULL for the datetime column, I > would like to have a NULL returned by getTimestamp at Java side. > > Pl. send you response to me at zli@us.ibm.com. > > Thanks, > Zhiyong Do you have a DEFAULT value of non-NULL set for the column in question? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.