Hello
FB3, database with 1 dialect.
I try to execute:
select CAST(CURRENT_DATE AS TIMESTAMP) from RDB$DATABASE
and see an error:
Dynamic SQL Error.
SQL error code = -104.
Client SQL dialect 1 does not support reference to DATE datatype.
For my point of view - server should prevent return DATE to client. Within,
server may work with DATE without any problem.
I know about "CAST('TODAY' AS TIMESTAMP)", question about CURRENT_DATE :)
Thanks,
Dmitry Kovalenko
www.ibprovider.com
|
