Dates

Researching SQL Server Dates issues? Check out these valuable tips, tutorials, how-to’s, scripts, and more perfect for SQL Server Developers.

Title Author Date
SQL Server Current Date Jim Evans2026-05-27
Creating a date dimension or calendar table in SQL Server Aaron Bertrand2026-05-13
Date Truncation with DATETRUNC() function in SQL Server Rajendra Gupta2026-05-06
Format SQL Server Dates with FORMAT Function Daniel Calbimonte2026-05-04
SQL Date Format Examples using CONVERT Function MSSQL Tips2026-05-02
Script to Create a SQL Time Dimension Table Koen Verbeeck2025-06-25
Simplify SQL Date Calculations – First, Last, Nth Day of the Month Aaron Bertrand2025-06-10
Calculate Difference Between Two SQL Dates as hh:mi:ss or hh:mi Sean Lee2025-05-27
SQL Convert Date to YYYYMMDD Jim Evans2025-05-27
SQL DATEFROMPARTS Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEPART Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEDIFF Function Use and Examples Daniel Calbimonte2025-04-28
SQL DAY Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATEADD Function Use and Examples Daniel Calbimonte2025-04-28
SQL CURRENT_TIMESTAMP Function Use and Examples Daniel Calbimonte2025-04-28
SQL YEAR Function Use and Examples Daniel Calbimonte2025-04-28
SQL SYSDATETIME Function Use and Examples Daniel Calbimonte2025-04-28
SQL DATENAME Function Use and Examples Daniel Calbimonte2025-04-28
SQL MONTH Function Use and Examples Daniel Calbimonte2025-04-28
SQL GETDATE Function Use and Examples Daniel Calbimonte2025-04-28
SQL GETUTCDATE Function Use and Examples Daniel Calbimonte2025-04-28
SQL ISDATE Function Use and Examples Daniel Calbimonte2025-04-28
Recommended SQL Server Date Formats Aaron Bertrand2025-04-27
SQL Server Date and Time Data Type Comparison Aaron Bertrand2025-04-27
SQL Server Between Dates Issue Aaron Bertrand2025-04-27
SQL Server Date Time Shorthand and Other Tricks Aaron Bertrand2025-04-27
Select SQL Server Data Between Two Dates Hadi Fadlallah2025-01-08
Add and Subtract Dates using DATEADD in SQL Server Tim Cullen2025-01-02
SQL Server Date and Time Functions with Examples Joe Gavin2024-12-31
Build a Time Slicer by Week using DAX Kenneth A. Omorodion2023-04-12
Learn about SQL Date Data Types – Date, DateTime, DateTime2, Time Hadi Fadlallah2023-03-15
TRY_PARSE Functionality for SQL Server 2008 to Determine Valid Dates Aaron Bertrand2023-03-09
SQL Calendar Table Simplified using a Table and a View Aaron Bertrand2023-02-22
Generate Events Calendar in HTML with SQL Server and CSS Aaron Bertrand2023-02-07
How to get Time from a RowVersion value with T-SQL Code Eric Blinn2022-12-02
Create an Extended Date Dimension for a SQL Server Data Warehouse Dinesh Asanka2022-08-04
Random Date Generator in SQL Server Jared Westover2022-07-12
DATEADD SQL Function to Add and Subtract Dates and Times Manvendra Singh2022-04-26
SQL DATEDIFF and DATEDIFF_BIG Functions with Sample Code Manvendra Singh2022-04-11
SQL Server datetimeoffset for Time Zones Eric Blinn2022-03-14
SQL Server FORMAT Dates, Numbers and SQL Server Agent Dates Jeffrey Yao2021-10-28
Create a Calendar Table in SQL Server to Optimize Scheduling Problems Aaron Bertrand2021-06-16
SQL DATE Functions Jim Evans2021-05-18
Calendar Table in SQL Server to Identify Date Gaps and Islands Aaron Bertrand2021-04-28
SQL Server Calendar Table Example Aaron Bertrand2021-04-22
SQL Server Date Format YYYY-MM-DD Considerations Aaron Bertrand2021-03-04
DATEDIFF SQL Server Function Jim Evans2020-07-16
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table Koen Verbeeck2020-07-15
Update only Year, Month or Day in a SQL Server Date Atul Gaikwad2019-11-14
Fill In Missing Dates for SQL Server Query Output Jim Evans2019-07-12
Simplify Date Period Calculations in SQL Server Aaron Bertrand2019-06-27
Get SQL Server Date and Time Parts with DATEPART and DATENAME Tim Cullen2019-05-24
SQL Server function to convert integer date to datetime format Tim Ford2019-05-24
Using T-SQL to find events that overlap (or don’t) in SQL Server Aaron Bertrand2018-12-26
SQL Server DateTime Best Practices Aaron Bertrand2017-11-15
Handling Special Dates For SQL Server Metrics Tim Smith2016-12-01
Build a cheat sheet for SQL Server date and time formats Aaron Bertrand2015-10-13
Converting and Using Text Dates as SQL Server Dates Rick Dobson2015-05-26
SQL Server Date Time Calculation Examples Jeffrey Yao2015-02-13
SQL Server Data Aggregation for Data with Different Sampling Rates Dallas Snider2014-12-04
Handle conversion between time zones in SQL Server – part 3 Aaron Bertrand2014-04-01
Handle conversion between time zones in SQL Server – part 2 Aaron Bertrand2014-03-10
Handle conversion between time zones in SQL Server – part 1 Aaron Bertrand2014-03-04
Restore SQL Server Databases using DateTime functions Brady Upton2012-12-21
SQL Server Function to return a range of dates Albert Hetzel2012-10-25
Work around for calculating age using the SQL Server DateDiff function Rick Dobson2012-05-09
New Date and Time Functions in SQL Server 2012 Ashish Kumar Mehta2012-01-09
SQL Server DateDiff Example Tim Cullen2011-10-10
Converting UTC to local time with SQL Server CLR Diana Moldovan2011-04-07
Mimic timestamp behavior of other database platforms to store last modified date Murali Krishnan2011-03-10
Convert SQL Server DateTime Data Type to DateTimeOffset Data Type John Sterrett2011-02-23
SQL Server Date function that determines date range based on weekday Tim Ford2009-06-10
SQL Server 2008 Date and Time Data Types Tim Ford2008-10-30
TSQL Function to Determine Holidays in SQL Server Tim Cullen2008-07-10
Daylight Savings Time Functions in SQL Server Tim Cullen2007-11-13