Answers for "get first day of this month sql"

SQL
5

sql first day of current year

SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0);			-- SQL Server
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;					-- Oracle
SELECT MAKEDATE(year(now()), 1);							-- MySQL
Posted by: Guest on July-03-2021
0

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
Posted by: Guest on February-25-2020

Code answers related to "get first day of this month sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language