[thelist] Understanding an SQL Problem
Rob Smith
rob.smith at THERMON.com
Tue Jan 7 16:15:09 CST 2003
Yet another time I solve my own problems,
SELECT count(TimeAccessed) AS Countings
FROM IntranetLog
where DateAccessed = '1/6/03' and Datepart(HH,TimeAccessed) = 11
Order by Countings
Now I just need to automate the hour accessed...
Thanks anyhow,
Rob.Smith
Great! next question:
Why doesn't this work:
SELECT HOUR(TimeAccessed) blah blah blah
Says 'HOUR' is not a recognized function, yet everywhere I've looked HOUR is
a valid function. Am I missing something...again?!
Rob
--
More information about the thelist
mailing list