Get first monday of month sql

select DATEADD(wk, DATEDIFF(wk,0,
            dateadd(dd,6-datepart(day,getdate()),getdate())
                               ), 0)  
--Change getdate to your variable

Similar codes

2 votes282 views1 answer
Oracle trace file
SQL
0 vote285 views1 answer
PSQL use LIKE with timestamps
SQL
10 votes293 views4 answers
Else if mysql
SQL
1 vote284 views1 answer
Oracle create as select
SQL
0 vote299 views1 answer
Write SQL in ruby on rails
SQL
4 votes254 views1 answer
Postgresql show current database
SQL
0 vote292 views1 answer
Mssql dockere
SQL
0 vote292 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote281 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote267 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL