Select records where time not monday

Question

I'd like to create a select statement with the following pseudocode:

select * from temperatures
where tm != monday

tm is a datetime field.

Simply read the manual to find the function to get the day of week. — dnoeth, May 19 '20 at 20:38

score 2 · Answer 1 · answered May 19 '20 at 20:47

2

 select * from temperatures
    where DATEPART(WEEKDAY, tm) != 2

answered May 19 '20 at 20:47

Orlando Seixas

The Impaler · Accepted Answer · 2020-05-19T21:03:11.923

1

You can use DAYOFWEEK():

select * 
from temperatures
where datepart(weekday, tm) <> 2

edited May 19 '20 at 21:03

answered May 19 '20 at 20:38

The Impaler

score 1 · Answer 3 · answered May 19 '20 at 20:43

1

in your case

select * from temperatures
where DATENAME(dw,tm) != 'monday';

answered May 19 '20 at 20:43

Mahmoud Kubrosli

3 Answers3