dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Wednesday Feb 26th 2020 by Hannes du Preez

Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.

To get the first date of the current month, you could a query similar to the following:

SELECT 
   CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())) +1, GETDATE()), 105) Day1;
Home
Mobile Site | Full Site