Subject | Re: [firebird-support] Re: Making evaluation of UDFs constant across a query |
---|---|
Author | Geoff Worboys |
Post date | 2011-04-05T02:08:09Z |
Regarding
current_timestamp
vs cast('now' as timestamp)
vs timestamp 'now'
I just hit this for myself. After reading the FB v2.1 release
notes I thought I understood that
timestamp 'now'
was the equivalent of
cast('now' as timestamp)
but after using it in a few places I found it is definitely not
the same. Nor is it quite the same as current_timestamp.
(I am currently assuming that "timestamp 'xxx'" is truly the
equivalent of cast('xxx' as timestamp) is most other cases.)
If this is intentional then probably the release notes need to
be updated. If this is not intentional, it is certainly
confusing, then a tracker item needs to be raised (I searched
but could not find one).
--
Geoff Worboys
Telesis Computing
current_timestamp
vs cast('now' as timestamp)
vs timestamp 'now'
I just hit this for myself. After reading the FB v2.1 release
notes I thought I understood that
timestamp 'now'
was the equivalent of
cast('now' as timestamp)
but after using it in a few places I found it is definitely not
the same. Nor is it quite the same as current_timestamp.
(I am currently assuming that "timestamp 'xxx'" is truly the
equivalent of cast('xxx' as timestamp) is most other cases.)
If this is intentional then probably the release notes need to
be updated. If this is not intentional, it is certainly
confusing, then a tracker item needs to be raised (I searched
but could not find one).
--
Geoff Worboys
Telesis Computing