Zeoslib Portal

How to send '::' via string to Postgresql?
Example: 'SELECT myfield_timestamp::date;' this is work fine in psql, but is rejected via ZQuery.

Thanks

Paulonki

Set ParamCheck to False if you don't need parameters.

Regards,

Ben

BTW if you do need parameters then just double the :s as below:

SELECT myfield_timestamp::::date;

Regards,

Ben

SELECT cast(myfield_timestamp as date);