| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> time issue
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
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lance Prais
INET: lprais_at_ts.checkpoint.com
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: ListGuru_at_fatcity.com (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). Received on Thu Jan 24 2002 - 16:26:46 CST
 |
 |