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

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Azure SQL - Handling JSON column in the table

By mohankumar.trs

Hi I want to convert table content which contain the json values in the...

ALTER DATABASE Issue

By genadyd

Hello, I faced  very strange issue. When I try from management studio to put...

Simple query question

By Mysterio

I'm new to SQL and I'm struggling to return a result set which I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers