Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql copy table to another table
Sql :: drop temp table if exists
Sql :: oracle running queries sql
Sql :: sql convert varchar to date
Sql :: check lock on table in sql server
Sql :: laravel jwt
Sql :: alter table name sql
Sql :: spring data.sql table not found
Sql :: sql delete all values in a column
Sql :: how to put value in variable mysql
Sql :: What is dialect for Postgres
Sql :: check if a column is a primary key in sql server
Sql :: sql declare variable
Sql :: postgresql contains
Sql :: How to pass password to mysql command line
Sql :: mariadb json select
Sql :: SQL Greater Than or Equal to Operator
Sql :: sql end of month
Sql :: postgresql get connection string
Sql :: with postgres
Sql :: how to combine 2 tables in mysql
Sql :: sql select rows with different values in one column
Sql :: mysql delete rows
Sql :: row to json in sql server
Sql :: data formate in sql
Sql :: sql select min row
Sql :: mysql utc to local time
Sql :: services.AddDbContext DataSource Sqlite
Sql :: sql server pivot rows to columns
Sql :: sql select date add day

Search

SQL

get first monday of month sql

ADD CONTENT