Duh. Thanks
Tom
On 31 May 2003 at 13:10, Tom Lane wrote:
> hodges(at)xprt(dot)net writes:
> > This works for me:
> > a=`eval date` # now $a is current date/time
> > psql tom -c "SELECT * FROM firesides where date > '$a'"
>
> > Now how to set $a to 3 days in the future?
>
> I dunno how you would do that on the shell-script side, but it's easy to
> do the date arithmetic on the SQL side instead:
>
> psql tom -c "SELECT * FROM firesides where date > (current_date + 3)"
>
> regards, tom lane
>