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.
