Subject | Re: [firebird-support] Re: Time zone offset in select |
---|---|
Author | Jiri Cincura |
Post date | 2006-06-18T12:52:01Z |
On 18.6.2006 14:06 Adam wrote:
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
http://blog.vyvojar.cz/jirka/ | http://photo.cincura.net
http://www.ID3renamer.com
> I could make a good case that CURRENT_UTC would be more useful thanIMHO current_timestamp is good. When your app. is working in local company
> CURRENT_TIMESTAMP. The client machines could then calculate local time
> from stored time + tz offset + dst bias.
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
http://blog.vyvojar.cz/jirka/ | http://photo.cincura.net
http://www.ID3renamer.com