"Ismael " <[EMAIL PROTECTED]> writes:
> I have a function declared as follows
> CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1
> numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1
> character varying, comentarios1 character varying)
> RETURNS integ
sorry, just discovered the answer, only need to cast the value like this
String sql = "SELECT * FROM insertaEgreso(?, ?, ?::DATE, ?, ?, ?)";
pst.setDate(3, date);
:)
>
>
> I have a function declared as follows
> CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importe
I have a function declared as follows
CREATE OR REPLACE FUNCTION insertaegreso(usuario1 integer, importepago1
numeric, fechapago1 DATE, concepto1 character varying, tipopagonomina1
character varying, comentarios1 character varying)
RETURNS integer ASimplementation
notice the field "fech