Subject Re: [firebird-support] Re: Time zone offset in select
Author Jiri Cincura
On 18.6.2006 14:06 Adam wrote:
> I could make a good case that CURRENT_UTC would be more useful than
> CURRENT_TIMESTAMP. The client machines could then calculate local time
> from stored time + tz offset + dst bias.

IMHO current_timestamp is good. When your app. is working in local company
or some branches, you can select all todays invoices using
order_date=cast(current_timestamp as date). But you're right, that sometimes
the current_utc will be great.

Maybe in FB2.x or 3.0. ;) I'll try to ask on devel list.

Jiri Cincura |