Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Scripts
Today's Tip
Join
Tutorials
DBA
Dev
BI
Categories
Webcasts
DBA
Dev
BI
Categories
SQL Server Dates Tips
Browse Categories
Aggregates
Application Development
Change Data Capture
Constraints
Data Science
Data Types
Database Design
Dates
Debugging
DevOps
Dynamic Management Views
Dynamic SQL
Encryption
Entity Framework
Error Handling
Excel Integration
Full Text Search
Functions - System
Functions - User Defined
Identities
Import and Export
In-Memory OLTP
JOIN Tables
LINQ
Microsoft Access
Microsoft Flow
Paging
Power BI
Python
Query Optimization
Query Plans
Scripts
Service Broker
Spatial Data Storage
SQL Injection
SQL Mgmt Objects (SMO)
Stored Procedures
Synonyms
T-SQL
Table Valued Parameters
Temp Tables
Temporal Tables
Testing
Transactions
Triggers
User Defined Type UDT
Views
XML
Calculations
Add and Subtract Dates using DATEADD in SQL Server
Creating a date dimension or calendar table in SQL Server
Handling Special Dates For SQL Server Metrics
Mimic timestamp behavior of other database platforms to store last modified date
Restore SQL Server Databases using DateTime functions
SQL Server Data Aggregation for Data with Different Sampling Rates
SQL Server Date Time Calculation Examples
SQL Server DateDiff Example
SQL Server Function to Determine a Leap Year
TSQL Function to Determine Holidays in SQL Server
Using T-SQL to find events that overlap (or don't) in SQL Server
Work around for calculating age using the SQL Server DateDiff function
Conversions
Convert SQL Server DateTime Data Type to DateTimeOffset Data Type
Converting and Using Text Dates as SQL Server Dates
Converting UTC to local time with SQL Server CLR
Date and Time Conversions Using SQL Server
Daylight Savings Time Functions in SQL Server
Determine SQL Server Date and Time Parts with DATEPART and DATENAME Functions
Handle conversion between time zones in SQL Server - part 1
Handle conversion between time zones in SQL Server - part 2
Handle conversion between time zones in SQL Server - part 3
SQL Server function to convert integer date to datetime format
Data
Create an Extended Date Dimension for a SQL Server Data Warehouse
Data Types
New Date and Time Functions in SQL Server 2012
SQL Server 2008 Date and Time Data Types
Date Range
Fill In Missing Dates for SQL Server Query Output
SQL Server Date function that determines date range based on weekday
SQL Server Function to return a range of dates
Formatting
Build a cheat sheet for SQL Server date and time formats
Format SQL Server Dates with FORMAT Function
Functions
Simplify Date Period Calculations in SQL Server
SQL Server Date and Time Functions with Examples
Troubleshooting
SQL Server DateTime Best Practices
More SQL Server Solutions
