Greetings and welcome to the SQL Coach blog!
It seems that many people are a little confused about working with time and dates in SQL databases.
Are you one of the people who are wondering about working with time in SQL?
Do you just want to know more about the sql server date time types?
If you answered "YES!" to either question you will want to check this blog daily because I will be posting a thorough and easy-to-follow description of the many options available when working with dates / time in SQL Server.
Assuming all goes to plan I will post this information by Friday night!
In the meantime, here is some information to get you started...
What is the difference between SMALLDATETIME and DATETIME?
"What's that", you ask? You never heard of this SmallDateTime data type?
You are not alone! Based on the databases I have worked in while helping my clients I think it is safe to say many people do not know about the SmallDateTime data type.
That does not change the fact that it does indeed exist. And yes, even your SQL Server 2000 has it!
Here are the main differences you should know about these two datetime types:
1. Range of Dates
A DateTime can range from January 1, 1753 to December 31, 9999.
A SmallDateTime can range from January 1, 1900 to June 6, 2079.
2. Accuracy
DateTime is accurate to three-hundredths of a second.
SmallDateTime is accurate to one minute.
3. Size
DateTime takes up 8 bytes of storage space.
SmallDateTime takes up 4 bytes of storage space.
Armed with this knowledge, you may want to use SmallDateTime instead of DateTime if you only need to represent dates from January 1, 1900 to June 6, 2079 and you do not need accuracy below 1 minute. Why? Simple! Using SmallDateTime will reduce the amount of data your queries are pulling back. The size of each row will be a bit smaller.
That's it for now... be sure to check back soon for more information on using datetime in SQL Server.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment