On Mon, Mar 21, 2005 at 08:33:43 -0600,
"Thomas F.O'Connell" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
