getCalendarQTR

The script returns the quarter and year of a date submitted in the form of '105' - first quarter of 2005 - and is useful for grouping data by calendar quarter. Easy to modify for fiscal quarters.

2005-04-07 (first published: )

81 reads

Blogs

More Azure Blob Storage enhancements

By

I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...

Daily Coping 25 May 2020

By

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

A Byte of Redgate–Bonus Queso Recipe

By

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...

Read the latest Blogs

Forums

HTML Mail with more than one line in Resultset

By tutter

Hello all, i would like to send a html Mail with sql server. But...

AS Tabular and Sample Data in VS

By philipp

Hello all, I really need your help – I want to use the sample...

SSIS Export Flat File as Fixed Width

By Oscar_Boots

Hi Forum, I have a table that uses the script below to create fields...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers