Monday, August 5, 2013

how to get the first day in a month using sql

To get the first day in a month using sql

SELECT DATEADD(M,DATEDIFF(M,0,GETDATE()),0) 'First Day in a Month'

No comments:

Post a Comment