Sending '::'

[Paulonki]

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

[btrewern]

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

Regards,

Ben

[btrewern]

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

SELECT myfield_timestamp::::date;

Regards,

Ben

[Dennica]

SELECT cast(myfield_timestamp as date);