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
-
Smart Cyber Practice to Protect Your Business (Presented by Minter Ellison Consulting)
Presented by Minter Ellison Consulting Date: Monday, 16 June 2025Time:…
-
Project Intelligence Developer Interview Experience
A successful interview for a Project Intelligence Developer role requires…
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 IICA Technology Expo – Perth Intelligence Developer Interview Experience Mac – Set Folder Permission News opendbiff Partition Perth 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 Technology Expo WA
Leave a Reply