Helen Borrie wrote:

>>> Lester Caine wrote:
>>>> Anybody have a sensible way of converting an SQL timestamp into
>>>> something I can use in Firebird.
>
> Why don't you just write a UDF?
> Info here:
> http://techpubs.sgi.com/library/tpl/cgi-bin/getdoc.cgi?coll=0650&db=man&fname=/usr/share/catman/a_man/cat8dce/utc.z

Actually Helen is there a 'feature request' for this. I'm obviously not
looking properly, but since this is the standard format for timestamps
it should probably be handled?

ccyy-mm-ddThh:mm:ss.sss{+02:00}
and
ccyymmddhhmmss{.sss{+02:00}}

Although just handling the 'T' would be a start.

I've got a faster PHP conversion running for now.

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php