Get Number of Days in month

Have seen existing scripts to work out number of days in month. They tend to work out the month, and then whether it's a leap year.Another approach is to take the date passed in, find the first day of the next month, and then use Datadd to take off one day, ie: last day of […]

4 (1)

2002-10-17

393 reads

Blogs

Do you have rarely used indexes that are hurting performance of writes?

By

We know that indexes are necessary for query performance but comes with overhead during...

Working with SQLSaturday SpeedPASSes – revamped!

By

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...

Happy Hour at SQL in the City Austin

By

Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Table type

By Admingod

I just want to validate my use of a custom type. I'm doing a...

How to save collapse sections of the query window and save it like that

By itmasterw 60042

Hi, My manager would like it that when he collapses certain parts of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers