Technical Article

Finding first/last day of month by a date

This script finds the first day of previous, current and next month as well as last day of previous, current and next month.The calculation is based on the ISO date format which makes it independant of the date format used on the SQL Server.The calculation is performed from a date - it can be altered […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-12-02 (first published: )

284 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

By

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

By

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

SSL/TLS Cert Validity Periods Decreasing

By Phil Parkin

Hi, to all of you who are using CA certs on SQL Server boxes...

It's Never Just One Thing

By Grant Fritchey

Comments posted to this topic are about the item It's Never Just One Thing

Calculating Min-Max Normalization in PowerBI

By Dinesh Asanka

Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers