Difficulty Makes a Good Developer
Friday, April 3, 2009
How to Find the 1st Day of week and Last Date of a month
SELECT DATEADD(WK, DATEDIFF(WK, 0, getdate() - 2), 0)
select DAY(DATEADD (m, 1, DATEADD (d, 1 - DAY(getdate()), getdate())) - 1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
Samir
Samir Balabantaray. I m working as a software Engineer from 2007.I have worked for ValleyInfosystems Pvt Ltd at Kolkata.Now i m working for Mahindra Satyam,Bangalore as a Sharepoint consoltant.
View my complete profile
Blog Archive
►
2016
(2)
►
June
(1)
►
May
(1)
►
2015
(2)
►
November
(1)
►
March
(1)
►
2014
(11)
►
November
(2)
►
September
(1)
►
August
(2)
►
June
(2)
►
March
(3)
►
January
(1)
►
2013
(7)
►
November
(3)
►
October
(4)
►
2012
(11)
►
November
(2)
►
October
(3)
►
August
(1)
►
July
(2)
►
May
(2)
►
April
(1)
►
2011
(10)
►
November
(1)
►
October
(9)
▼
2009
(7)
►
December
(1)
►
July
(2)
►
June
(1)
▼
April
(2)
How to Find the 1st Day of week and Last Date of a...
Fetch XML format Data in SQL server
►
February
(1)
►
2008
(1)
►
April
(1)
No comments:
Post a Comment