Subject | Cannot calculate value between date and timestamp |
---|---|
Author | H |
Post date | 2003-05-14T04:13:24Z |
Hi,
I cannot calculate number of days between a date value and a
timestamp value in the select statement, such as
select current_date-current_timestamp from ...
It shows error:
expression evaluation not supported.
I have to cast them as the same type. Is it a bug or intended to be
so?
It happens with RC2.
Thanks,
Hong
I cannot calculate number of days between a date value and a
timestamp value in the select statement, such as
select current_date-current_timestamp from ...
It shows error:
expression evaluation not supported.
I have to cast them as the same type. Is it a bug or intended to be
so?
It happens with RC2.
Thanks,
Hong