My boss wants me to break down some data into hourly activity instead of just daily activity, but I am having trouble extracting the hour. I haven't found in my SQL book how to do this. In my SQL statement I am trying to get just the hour from a timestamp. I am saying "SELECT hour(myDateField) AS theHour FROM myTable". It doesn't recognize my attempt to use an 'hour' function. Do you know how I can get just the hour (1-24)?<BR>Thanks for any help!