[RESOLVED] Timestamp

[raouleduke]

I want to report on if a timestamp was Before 5pm/weekdays or After 5pm and Weekends. I am currently tracking after 5pm and before 5pm by using this:

//before 5pm
TIME(completed_datetime) < '17:00:00' AND TIME(completed_datetime) > '00:00:00' 
//after 5pm
TIME(completed_datetime) > '17:00:00' AND TIME(completed_datetime) < '23:59:00'

I need to differentiate the weekends and put them into the after 5pm category, but have no idea how to do this, any help would be appreciated.

[_uk_stuff]

If you place the timestamp into the date() function it can return the day of the week 0 = Sunday, 6 = Saturday. This could then indicate whether the timestamp is on a weekend...

I would suggest looking at http://www.php.net/date

[raouleduke]

I actually used the SQL Function to get what I needed. WEEKDAY(completed_datetime) >= '5' Thank you very much for your post and help.