SQL Server Transact Basic to Expert - Incrementing a date value by Quarter

Karthikeyan Anbarasan
13y
2.8k
0
0

Blog

This blog shows how to do an date increment to a quarter in the output using SQL Query

Example:

SELECT DATEADD(q, 1, '2/2/2011')

The expected result would be 2011-05-02 00:00:00.000

SQL Server Transact Basic to Expert - Incrementing a date value by Quarter

Up Next

SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

Ebook Download

View all

Functions in SQL Server: Practical Guide

Read by 9k people

Download Now!

Learn

View all