Tuesday, April 7, 2015

get specific day previous month t - sql

get specific day previous month t - sql
there is about six million different ways to compose these queries

select convert(date, concat( Datepart(m,DATEADD(m,-1,getdate())),'/','10','/',datepart(year,getdate())))

No comments: