Subject | Re: [firebird-support] UTC Time from server |
---|---|
Author | Richard |
Post date | 2005-08-27T22:17:35Z |
Ivan Cruz wrote:
I have had a look in Helen Borie's book (The Firebird book), but can't
see a reference.
Richard
> Richard wrote:Does that mean that you *can't* get the server UTC time?
>
>>Hi,
>>
>>What SQL syntaxt would I use to retrieve the UTC time from a Firebird
>>1.5 server?
>>
> You can recover the system time (from your mainboard clock) using
> select CURRENT_TIMESTAMP from RDB$DATABASE
> for UTC time I believe an SNTP client would be the better tool.
I have had a look in Helen Borie's book (The Firebird book), but can't
see a reference.
Richard