I have not tried it but typically, SQL dates are in a format of YYYY-MM-DD-hh.mm.ss.nnnnnn.
Have you tried Current_timestamp? The following sql command generated output like what follows: select filespace_name as "Filespace", node_name as "Node", current_timestamp-backup_end as "time since backup" from filespaces SYSTEM OBJECT NPRDBPN1 0 13:43:08.000000 \\nprdbpn1\c$ NPRDBPN1 0 13:48:14.000000 \\nprdbpn1\e$ NPRDBPN1 0 13:48:06.000000 \\nprdbpn1\f$ NPRDBPN1 0 13:47:58.000000 \\nprdbpn1\g$ NPRDBPN1 0 13:46:29.000000 \\nprdbpn1\h$ NPRDBPN1 0 13:46:11.000000 \\nprdbpn1\i$ NPRDBPN1 0 13:43:27.000000 Based on a quick look at the SELECT help, it looks like you could do almost anything. -----Original Message----- From: Joseph Dawes [mailto:[EMAIL PROTECTED]] 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))
