Find starttimes past 7pm on Fridays

[gcoast]

I need a query that will find shift times starting after 7pm on Fridays. I know I can use the "datepart(dw, starttime) to find the dow but I just need the records past 7pm. I need to query from a schedule table that has schedules for the next 6 months.

Thanks,

gc

 

[gmmastros]

You can also use DatePart to get the hour. This will return an integer representing the hour. This is 'military time' so 2 PM is 14.

Select DatePart(Hour, GetDate())


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom