'where backup_date=current_timestamp - 3 days'
or
'where backup_date>current_timestamp - 3 hours'
or
'where (backlup_date between '2013-07-01 12:00:00' and '2013-07-01
18:00:00')



On 31 July 2013 16:22, Lee, Gary <GLEE AT bsu DOT edu> wrote:

> Not sure where to look for this answer, so a pointer wil work as well.
>
> I want to show files backed up for a node on a particular date.  However,
> the date stamp is a bit unwieldy to use.
>
> How can I say something like files backed up today - 3  or today - 2?
> I know that durrent_date is today.
>
> Thank you for any enlightenment
>