End day of last month


 

SELECT DateAdd(second, 1, DateAdd(month, DateDiff(month, 0, GETDATE()), 0) ) AS LastMonthEnd

 

Datediff and dateadd are two very important date function. It can address many date related questions.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s