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
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel