[thelist] Understanding an SQL Problem

[Rob Smith]

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
--