Re: datetime insert/update

In article <3429E9DD.6212@uniteq.com>, CDware user <cdware@sun.com> wrote: > How to insert or update in a datetime column using datetime function?? > e.g. Have a table col1 datetime year to fraction(3). > Want to insert 1. '12/12/97' > 2. '12/12/97 00:00:00.0' > > How to do this using datetime functions. I tried setting DBTIME/DBDATE >but didn't work. > Any help appreciated. You might start with a valid datetime literal, e.g. "1997-12-12 00:00:00.0" -- Alan Denney aland_at_informix.com yosemite_at_netcom.com Speaking from, but not for, Informix Platform Engineering "My opinions may have changed, but not the fact that I am right." -- Ashleigh Brilliant