ADSM-L

select on events table question

2005-10-14 18:00:17
Subject: select on events table question
From: TSM_User <tsm_user AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 14 Oct 2005 14:59:52 -0700
I know that per APAR IC28825 if you try running select * from events you will 
only get the events for today.

 

That APAR lists a work around where running select count(*) from events where 
scheduled_start between '2005-10-01 18:00:00' and '2005-10-15 06:00:00' will 
actually give you the events for a date range. With this I have to update the 
range each time I run it.

 

I tried to use the timestamp with between as follows select count(*) from 
events where scheduled_start between timestamp(current date - 30

day,'18:00:00') and timestamp(current date,'18:00:00'). But when I use 
timestamp it reverts back to the problem where it only shows you todays event 
data.

 

Just wondering if Andy or any other SQL guru's out there might now if I am 
using timestamp incorrectly with between.

Kyle


                
---------------------------------
 Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

<Prev in Thread] Current Thread [Next in Thread>