Re: [SQL] date question

[lucas]

Quoting Judith Altamirano Figueroa <[EMAIL PROTECTED]>:

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()??

Try using "now()::date", or "interval". Like:
 select * from clientes_proceso where fecha_mod::date <= now()::date -1;
or:
 select * from clientes_proceso where fecha_mod::date <= now() - '1
day'::interval;
---
Lucas


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend