Lester Caine wrote:

> 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

8601 even - and W3C base format.

> 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