willogibbo wrote:

> Hi all
>
> I am trying to understand the way time is stored in Firebird and how
> to relate it to local time.

Firebird stores local system time. Whatever your OS says the time is,
that's what we store.

>
> I see in documentation (e.g. Helen's book, page 150) that FB uses two
> components for storing time, namely days from Nov 17, 1898

1858, but that's not a big issue.

> and ten
> thousandths of seconds from midnight. I am right to presume that this
> is done if effect on a GMT/UTC type basis, so that as FB stores a
> date/time it takes the locale into account and makes the necessary
> adjustment before it stores the time value, and then when the stored
> value is retrieved it also takes the locale into account before display?

Nope. If you use 'now', 'today', or CURRENT_TIMESTAMP, or CURRENT_TIME,
or "CURRENT_DATE", we call localtime. If you need to keep time to some
other standard, I'd suggest using a UDF.


Regards,


Ann