Richard Salt wrote:

> Hi All
>
> Having searched the posts, I understand that Firebird doesn't include
> a function such as current_timestamp_utc.
>
> Before I embark on attempting to write a UDF to do this, I thought I
> would ask if any of you kind souls have already written one?
>
> Ultimately I will need this for both Linux AND Windows but, at this
> time, just a Windows one will suffice.
>
> Any help much appreciated.

It's a can of worms!
The main problem is knowing what offset a time is and that depends on the
client end. What *I* do is run the server AT UTC so that all the
current_timestamp entries are only UTC, then when you ask to display a time
you can convert it in the client.

Add different daylight savings offsets and the display function becomes even
more fun!

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php