Hi,
I was wondering if this would work. I do not know mySql so it is just a guess
from looking at the documentation online:
Select
CASE WS_WeekDay
WHEN 'Monday' THEN 1
WHEN 'Tuesday' THEN 2
WHEN 'Wednesday' THEN 3
WHEN 'Thursda
not exactly sure but can't you convert the date into a Julian date and then
divide 7. so can't the day of the week can be obtained from the remainder of
the division of the Julian date by 7.
http://aa.usno.navy.mil/data/docs/JulianDate.html
-Original Message-
From: Rick Faircloth [mail
2 matches
Mail list logo