Question regarding offsetting times

[mad4it]

Hi,

 

I currently have a simple piece of code that does this :

 

Select * from Calendar where calendar.entryDate = CURDATE()

 

This works fine, at midnight server time the results set changes from one day to the next.

 

However the client has a requirement for Mondays results to remain live until 6am Tuesday morning and so on - effectively a 6 hour offset - can anyone provide any suggestions on how to alter the query/code accordingly?

 

Thanks in advance!