| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com> |
| Cc: | Chandan_Kumaraiah <Chandan_Kumaraiah(at)satyam(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: query |
| Date: | 2005-03-21 15:17:35 |
| Message-ID: | 20050321151735.GA20261@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Mar 21, 2005 at 08:33:43 -0600,
"Thomas F.O'Connell" <tfo(at)sitening(dot)com> wrote:
> You should be able to use the CURRENT_DATE function in place of sysdate.
>
> You might need to cast the 1 explicitly to an interval.
>
> As in:
>
> CURRENT_DATE - '1 day'::interval
I don't think you want that. That is going to force a conversion from date
to a timestamp. You are going to be better off just using:
current_date - 1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Borg Salling | 2005-03-21 21:57:13 | "Flattening" query result into columns |
| Previous Message | Martín Marqués | 2005-03-21 14:40:15 | Re: CASE not working |