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 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:[EMAIL PROTECTED]]On Behalf Of > Joseph Dawes > Sent: Wednesday, December 12, 2001 10:19 AM > To: [EMAIL PROTECTED] > 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)) >
