List:General Discussion« Previous MessageNext Message »
From:Douglas Brantz Date:March 16 2000 4:14am
Subject:Time Between Thursday & Thursday
View as plain text  
Wondered if anyone had a good way of grabbing records for a table that
occured every week - Thursday to the next Thursday.

timestart= a timestamp(14) field.

Can I use Select * from timecards where timestart between $hour and
$hour +168 and start where $day="Thursday".

I just need this generic enough to do this every week from Thursday to
Thursday.

Any help would be greatly appreciated:

Thanks,

Douglas

Thread
Time Between Thursday & ThursdayDouglas Brantz16 Mar