ian wrote:

> Hi,
>
> Lester Caine wrote:
>>
>> Anybody have a sensible way of converting an SQL timestamp into
>> something I can use in Firebird.
> Do you mean a timestamp value from SQLServer? A SQLServer timestamp is
> not a date/time value as defined in the SQL92 standard, or as used in
> Firebird. If this is the case, do not rely on this value to indicate an
> accurate "time", for indentifying when something happed.

No SQLServer involved, done my homework and it *IS* ISO8901 format which
does now form part of SQL2003 - at least the information I have. It is
also an acceptable format for SQL92.
I need to get a 3.2Gb file with all the datestamps in this format into
Firebird and translating them every time is taking too long.

>> 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?
>>
> Sorry, not me, I do not use timestamps in SQLServer.

As I say - no SQLServer- pure international standard :(

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