25/04/2021 23:47:20  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_clienteInvalid query: ERROR:  date/time field value out of range: "25-04-21"
LINE 61: ....00','0.00','0.00','0','0','0','0','0','0.00','0','25-04-21'...
                                                              ^
HINT:  Perhaps you need a different "datestyle" setting.
Whole query:  SELECT setval('cxc_clientes_id_cliente_seq', max(id_cliente)) FROM cxc_clientes; INSERT INTO cxc_clientes(
											    codemp,
												codcliente,
												tipperrif,
												numpririf,
												numterrif,
												nitcli,
												id_tipo_cliente,
												nombre_cliente,
												cliente_abvr,
												id_zona,
												id_vend,
												id_clasif_cliente,
												dircliente,
												direntrega,
												codpai,
												codest,
												codmun,
												codpar,
												codciu,
												codpostal,
												faxcliente,
												telcliente,
												emailcliente,
												webcliente,
												observcliente,
												sc_cuenta,
												estclient,
												limitecred,
												diascred,
												descglob,												
												cedularesp,
												nombreresp,
												cargoresp,
												emailresp,
												cupocestas,
												retmensual,
												fondogar,
												alquilervehiculo,
												retfinmes,
												descarta,
												descartb,
												descartc,
												descartd,
												tipfongar,												
												porcahoaso,
												facnctercero,
												fecregcliente,
												retivaauto,
												retislrauto,
												retauto1,
												retauto2,
												retauto3,
												sucadscli,												
												id_ruta,
												tarcostcli,
												fecreg,
												usureg,
												horareg
										) 
										 VALUES ('0001','998','J','08500776','8','','11','100% BANCO, BANCO UNIVERSAL, C.A','','2','1','01','AV. BLANDIN C.C SAN IGNACIO, TORRE COPERNICO NIVEL PISO 10 OF TO-P10-01 URB LA CASTELLANA','','---','---','---','---','---','','','02122771136.02122775308 ','','','','102020100','A','0.00','0.00','0.00','','ANDRES IGLESIAS','','','0.00','0.00','0.00','0.00','0.00','0','0','0','0','0','0.00','0','25-04-21','0.00','0.00','0.00','0.00','0.00','0001','0','','2021-04-25','ADMINISTRADOR','23:47'); ; SELECT lastval() AS valor_id;