This is not a valid SQL statement based on my knowledge of SQL. The reason is DAYS is an INTEGER DECIMAL(15,0). Cannot use a floating to achieve what you are trying to do.
The actual way to do this is: where (backup_end <current_timestamp - 1 hours) There are all kinds of modifiers that you can use on the integers to make them work in date duration calculations. These are standard SQL capabilites. -----Original Message----- From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 10:50 AM To: [EMAIL PROTECTED] Subject: Re: filespace reporting question 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)) >
