LINE 1: ...r)) as total from compras te where fecha_sale like '2013...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Coloreado en 0.000 segundos, usando GeSHi 1.0.8.4
Using sql Syntax Highlighting
- SELECT sum((sub*tir)) AS total FROM compras WHERE fecha_sale LIKE '2013-01-%';
Coloreado en 0.001 segundos, usando GeSHi 1.0.8.4
y me manda el siguiente error:
Using text Syntax Highlighting
ERROR: operator does not exist: timestamp without time zone ~~ unknown
LINE 1: ...r)) as total from compras te where fecha_sale like '2013...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
LINE 1: ...r)) as total from compras te where fecha_sale like '2013...
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Les agradeceré su apoyo ya que no me queda claro qué es lo que está sucediendo.
La versión de PostgreSQL es 9.2.18.
Gracias.
