devxlogo

Get the First Day of the Current Month

Get the First Day 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;

devx-admin

Share the Post: