On 8/28/2005 at 7:48 AM Richard wrote:

> Thanks for that, I suppose now, I am going to have to work out what time
> zone the server is in, so that I can do my conversion?
> Is that straight forward?
> It's a bit of a shame because I am converting from MySQL and that has a
> "get server time in utc" function.
> Richard
>
>

Since the server can provide UTC time to a local program, why don't you just write a UDF to get the UTC time and return it to the client that way?

Dan.