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: [url]http://www.hrnz.co.nz/eDisclaimer.htm[/url]

sending to informix-list