Update only Year, Month or Day in a SQL Server Date
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
In this tip we look at how to change specific parts of a date such as the Year, Month or Day for data stored in a SQL Server table.
2019-12-17
2017-11-20
619 reads
An inline table valued function (iTVF) that can be used to calculate age in years.
2016-04-27 (first published: 2016-04-06)
970 reads
Find minimum and maximum values for all date columns in a table or range of tables, using a mask.
2016-09-15 (first published: 2014-10-27)
2,443 reads
2013-03-11 (first published: 2013-02-20)
2,054 reads
Code to create a handy date calendar cross-reference table with a ton of pre-populated, slice-and-dice data field variations to aid in complex date parameterization / selection criteria.
2018-04-26 (first published: 2009-10-06)
13,992 reads
This function will return the first, second, third, fourth or last day of a given month.
2009-03-03 (first published: 2009-02-10)
1,139 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...
Hi. I am trying to download a report from SSRS 2019 in word format...
I've yet to find an answer for this. I've found a few queries that...