Answers for "how to get first day of the month in 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

Code answers related to "how to get first day of the month in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language