How To Avoid 1900-01-01 For Empty Dates In Sql Server

2026 1:26
Synopsis
Discover how to correctly handle empty date values in SQL Server to prevent getting `1900-01-01` instead of `NULL` in your query ...

You Might Also Like

Solve the Null Date Issue in SQL: Replace 1900-01-01 with a Blank Value 1:36
Solve The Null Date Issue In Sql: Replace 1900-01-01 With A ...
2026
Show Blank Instead of 101900 in Excel | Don't Show 1900 on Blank Date | Leave Blank If No Date 4:00
Show Blank Instead Of 101900 In Excel | Don't Show 1900 On B...
2023
Two ways in query to show NULL Values when date field is 1900- 01-01 in SQL Server 4:15
Two Ways In Query To Show Null Values When Date Field Is 190...
2025
Fixing DateTime Insertion Issues in SQL Server with NULLIF 1:36
Fixing Datetime Insertion Issues In Sql Server With Nullif
2026
SQL : Blank values in Date column returning as 1900/01/01 on running SELECT statement 1:27
Sql : Blank Values In Date Column Returning As 1900/01/01 On...
2024
Databases: SQL Server 2016 ISNULL Returning 1900-01-01 2:40
Databases: Sql Server 2016 Isnull Returning 1900-01-01
2022
Why Casting an Empty String to Datetime Returns January 1, 1900, in SQL Server 2005 3:03
Why Casting An Empty String To Datetime Returns January 1, 1...
2025
Databases: SQL Server Isnull Returning 1900-01-01 when field is null 2:09
Databases: Sql Server Isnull Returning 1900-01-01 When Field...
2022
Solving the Issue with MIN and MAX Dates in SQL Queries 2:15
Solving The Issue With Min And Max Dates In Sql Queries
2026
SQL : SQL Server inserting Date as 1/1/1900 1:15
Sql : Sql Server Inserting Date As 1/1/1900
2024
How to Convert Varchar to Date in SQL Server while Returning a Blank for NULL Values 1:23
How To Convert Varchar To Date In Sql Server While Returning...
2026
Download Options
Choose a download method below. All links open in new tabs.
Service Features Action
Ssvid
MP4 & MP3 • HD Quality • Browser Extension Available
Download
SaveFrom
MP4 & MP3 • HD Quality • Browser Extension Available
Download
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.