You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It's intended. 'now' is a runtime expression, while timestamp 'dd.mm.yyyy' is a compile-time literal. timestamp 'now' is something in the middle and doesn't make much sense. See CORE5717.
Submitted by: @sim1984
Votes: 1
select
current_timestamp as t1,
timestamp 'now' as t2,
cast('now' as timestamp) as t3
from rdb$database
Overflow occurred during data type conversion.
conversion error from string "now".
If you comment out the column t2, then it works.
select
current_timestamp as t1,
-- timestamp 'now' as t2,
cast('now' as timestamp) as t3
from rdb$database
The text was updated successfully, but these errors were encountered: