I never tried this, but since one hour is .04166 days, can you say
 ...where (days(backup_end) < (days(current_date)-.04166) ...
?


----------------------------
Mr. Lindsay Morris
Mr. Lindsay Morris
CEO
Applied System Design
www.servergraph.com <http://www.servergraph.com>
859-253-8000 ofc
425-988-8478 fax


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Joseph Dawes
> Sent: Wednesday, December 12, 2001 10:19 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: filespace reporting question
>
>
> Does anyone know how to use a select statement like the following but
> instead of having it report on days have it report on hours? i.e. from now
> -3 hours and less than 15 days.
>
>
>
> select filespace_name as "Filespace", node_name as "Node",
> days(current_date)-days(backup_end) as
>                                  "Last Backup",dayname(backup_end) as "Day
> of Week" from filespaces where (days(backup_end) <
>                                  (days(current_date)-1) and
> (days(current_date)- days(backup_end) <= 15))
>