[Firebird-devel] CURRENT_DATE in 1 dialect

[Kovalenko D. <dmi...@gm...>]

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