On Mon, Mar 21, 2005 at 08:33:43 -0600, "Thomas F.O'Connell" <tfo@sitening.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