date question

From: Judith Altamirano Figueroa <jaltamirano(at)correolux(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: date question
Date: 2005-11-03 16:17:52
Message-ID: 1131034672.3600.74.camel@Desarrollo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2005-11-03 17:22:24 Re: date question
Previous Message Don Drake 2005-11-03 16:14:28 Encoding on 8.0.4