recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: time issue
Just
Select count(*) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440);
should do it (no 'group by').
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original
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 =
Just
Select count(*) users
from cp_license_use
where Time_Stamp between SYSDATE and (sysdate - 30/1440);
should do it (no 'group by').
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 24,
Change it to between (sysdate - 30/1440) and sysdate
Jared
Lance Prais [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 01:35 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:time issue
I am
I'm pretty sure the earlier date must be referenced first.
At 01:35 PM 1/24/02 -0800, you wrote:
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
Igor,
That SQL will always return zero rows.
Jared
Igor Neyman [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/24/02 02:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: time issue
Just