How to be start a week @ 3am Monday

[yshum157]

I need to group a bunch of timestamped events into weeks. I use DATEFIRST = 1 to set Monday as the beginning of a week. Is it possible to set the beginning of a day as 03:00 instead of 00:00? In other words, events happened between Monday's 00:00 and 02:59 will be considered as previous week's when using datepart.

Many thanks in advance.

 

[Moptop]

Hi

Can't you simply subtract 3 hours from the date/time before checking the day?

Mark