On Nov 4, 2005, at 1:17 , Judith Altamirano Figueroa wrote:
Hi everybody, in Postgres 7.0.2 I have the next query:
SELECT * from clientes_proceso where fecha_mod::date <= now() -1;
but in version 8.0.1 returns the next error:
ERROR: The operator doesn't exist: timestamp with time zone - integer
How can drop a day to now()??
You can try a couple of different things: one is to use CURRENT_DATE
- 1 instead of now() -1. Another would be to cast now() to date,
e.g., now()::date - 1.
Hope this helps.
Michael Glaesemann
grzm myrealbox com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
