Anybody have a sensible way of converting an SQL timestamp into
something I can use in Firebird.

2005-02-03T15:30:00+01:00 is being provide by the raw feed, and I need
to convert it to an internal UTC timestamp in the database.

SUBSTRING( :TS FROM 1 FOR 10 ) || ' ' || SUBSTRING( :TS FROM 12 FOR 8 )
may be workable, if I ignore the offset, but I'm sure someone must have
hot this problem already?

--
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