Advanced Search

Getting Dates in Sql Server

/ Published in: SQL
Save to your folder(s)
Following query will run respective to today’s date. It will return Last Day of Previous Month, First Day of Current Month, Today, Last Day of Previous Month and First Day of Next Month respective to current month.

Highlighted TextExpand

URL: http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.