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
-
Ref 1: With using ajax cascading dropdown list http://csharpdotnetfreak.blogspot.com/2009/02/ajax-cascading-dropdownlist-database.html ...
-
We can use the convert function SELECT [Datetime] = CONVERT(datetime,'2010-02-28') For more formats refer http://www.sqlusa.com/b...
No comments:
Post a Comment