DATETIME column must fall within the range of January 1, 1753, through December 31,
9999.
SMALLDATETIME column must fall within the range of January 1,
1900, through June 6, 2079.
Hence we can use Smalldatetime for most of our apps.
Ref:http://suryan72.blogspot.com/2008/08/date-time-vs-small-datetime-in-sql.html
Subscribe to:
Post Comments (Atom)
Devops links
Build Versioning in Azure DevOps Pipelines
-
Build Versioning in Azure DevOps Pipelines
-
Generate Dates and hour between Date Range DECLARE @start DateTime = getdate() -1, @end DateTime = getdate(); ; WITH Dates_CTE ...
-
1. To get Simply the table names for a column name SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like &...
No comments:
Post a Comment