RE: to_date function: format parameter for fractions of a second?

Posted in 2003

Bryce Stenberg — Wed, 30 Jul 2003 10:37:17 +1200 — source: Usenet: comp.databases.informix

Thanks June, that answer works a treat. Regards, Bryce Stenberg. Harness Racing New Zealand computer department, emailto:bryce@hrnz.co.nz > -----Original Message----- > From: June Hunt [mailto:june_c_hunt@hotmail.com] > Sent: Wednesday, 30 July 2003 7:20 a.m. > To: Bryce Stenberg > Subject: Re: to_date function: format parameter for fractions of a > second? > > > Building on something that Jonathan Leffler suggested back on > 2002-11-14 > (see Re: merge DATE and TIME to DATETIME), the following > might be helpful: > > UPDATE xxx SET new_date = EXTEND(my_date, YEAR TO SECOND) + > (INTERVAL(00:00:00) HOUR TO SECOND + my_time)> > I ran a quick I4GL test with this code, and it worked for me > against an > older SE database. > > -- > June Hunt > DISCLAIMER: http://www.hrnz.co.nz/eDisclaimer.htm sending to informix-list