SQL CASE WHEN

Select Case Hour(Now())
Case 0
'Do whatever needs to be done at midnight
Case 1
'Do whatever needs to be done at 1:00 am
Case 2
'do

else

'do this
End Select