Start Date of the Month

Question

Post reply

Start Date of the Month

itskumar2004

Default port

Points: 1446
More actions
April 9, 2010 at 7:10 am

#213630

Hi ,
Can Any one tell me how to get start date of the month.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 1

I recommend that you use the Search feature on this site before you post in the future. 😀

SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)

Can be found from yesterday's article here --> http://www.sqlservercentral.com/articles/Date+Manipulation/69694/ 😉

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg

darkfour Old Hand Points: 383 More actions · Answer 2

All months start on the first;-)

Do you mean the day of the start of the month?

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

Jason Selburg (4/9/2010)
I recommend that you use the Search feature on this site before you post in the future. 😀
SELECT DATEADD(mm, DATEDIFF(mm,0,GETDATE()), 0)
Can be found from yesterday's article here --> http://www.sqlservercentral.com/articles/Date+Manipulation/69694/ 😉

Also add this link to your toolbox

https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

itskumar2004 Default port Points: 1446 More actions · Answer 4

I recommend that you use the Search feature on this site before you post in the future.
http://www.sqlservercentral.com/articles/Date+Manipulation/69694/

I did search the site and found this article but got confusion with the name ,i didn't know it is going give me exact results i want .sorry for that.

Thank you for all the articles .

Jason Selburg SSC-Insane Points: 24641 More actions · Answer 5

itskumar2004 (4/9/2010)
I recommend that you use the Search feature on this site before you post in the future.
http://www.sqlservercentral.com/articles/Date+Manipulation/69694/
I did search the site and found this article but got confusion with the name ,i didn't know it is going give me exact results i want .sorry for that.
Thank you for all the articles .

No apologies necessary! I was just giving my suggestion... 😀

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg