Someone may need to use Zero Date instead of null with datetime datatype
SELECT CONVERT(DATETIME,’1900–01–01 00:00:00.000′)
Return Result:
1900-01-01 00:00:00.000
More Articles & Posts
-
Project Intelligence Developer Interview Experience
A successful interview for a Project Intelligence Developer role requires…
-
Boost Your Digital Marketing Career with Meta Certifications
Boost Your Digital Marketing Career with Meta Certifications Are you…
-
4–5 June, 2025 -AWS Summit Sydney 2025 Livestream: Experience the Future of Cloud and AI from Anywhere!
AWS Summit Sydney 2025 Livestream: Experience the Future of Cloud…
Search
Popular Posts
Categories
- Events
- Ext JS
- htaccess
- IBM
- Interview Questions and Answers
- Livestream
- Meta Certifications
- Microsoft Fabric
- News
- PHP
- Project Management
- Python
- SQL Advanced
- SQL Alter Columns
- SQL Basic
- SQL Collation Conflict
- SQL Constraint and Keys
- SQL CTE
- SQL Database Schema
- SQL Datetime
- SQL Download
- SQL Membership Provider
- SQL Record Duplicate
- SQL Server 2008
- SQL Server Connection
- SQL Server Connection Error
- SQL Server Cursor
- SQL Server Functions
- SQL Stored Procedures
- SQL System Tables
- SQL Table Columns
- SQL Temp Table
- SQL Transact
- SQL Union All
- SQL Update
- Uncategorized
- WordPress
Archives
Tags
ASP.NET Membership services database Automate Python Scripts AWS Summit Sydney 2025 Compare SQL Database Schemas Tool Database Copy Tool Database Restore database schema comparison tool Eisenhower Matrix Events Ext JS – Combobox htaccess Intelligence Developer Interview Experience Mac – Set Folder Permission opendbiff Partition Project Management Python RANK Rename database ROLLBACK TRANSACTION ROW_NUMBER SAS SAS Questions and Answers SPSS SPSS Questions and Answers SQL Database Exists SQL EBooks SQL Remove Column SQL Scalar Values Functions SQL Server 2012 PDF SQL Server Reporting Services SQL SERVER – Database SQL Stored Procedure SQL Transaction Teach Yourself SQL
Leave a Reply