I am using the following Statement: I am getting no records returned. Any idea what is wrong? thanks again Lance
Select count(User_name) users from cp_license_use where Time_Stamp between SYSDATE and (sysdate - 30/1440) group by Time_stamp To grab data from the following table: SYSDATE = 1/24/2002 9:33:16 PM User_Name Time_stamp dsilver 1/24/2002 9:31:33 PM cnelson 1/24/2002 9:31:33 PM eho 1/24/2002 9:31:33 PM mreza 1/24/2002 9:31:33 PM kjuneja 1/24/2002 9:31:33 PM sislam 1/24/2002 9:31:33 PM dkotha 1/24/2002 9:31:33 PM mbalthrop 1/24/2002 9:31:33 PM tchung 1/24/2002 9:31:33 PM cnifong 1/24/2002 9:31:33 PM sluc 1/24/2002 9:31:33 PM dtrevino 1/24/2002 9:31:33 PM ddobson 1/24/2002 9:31:33 PM echinwub 1/24/2002 9:31:33 PM dmoses 1/24/2002 9:31:33 PM gpratt 1/24/2002 9:31:33 PM syahmed 1/24/2002 9:31:33 PM mreza 1/24/2002 9:31:33 PM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lance Prais INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).