Re: time issue

2002-01-25 Thread Igor Neyman
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

time issue

2002-01-24 Thread Lance Prais
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 =

Re: time issue

2002-01-24 Thread Igor Neyman
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,

Re: time issue

2002-01-24 Thread Jared . Still
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

Re: time issue

2002-01-24 Thread Regina Harter
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

Re: time issue

2002-01-24 Thread Jared . Still
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