CODEWITHSUNDEEP
visual-studiosql-server-2005datetimesmalldatetimesql-types
Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104741

datetime vs smalldatetime

If I don't care about less than seconds, what should be the recommended type to store my datetime values in sql-server 2005, is it datetime or smalldatetime or else?

Upvotes: 5

Views: 7744

Answers (3)

Justin Grant
Justin Grant

Reputation: 46683

smalldatetime has a resolution down to one minute, so if that resoulution is OK for you, smalldatetime is 50% smaller (4 bytes vs. 8 bytes) so is preferred.

See http://karaszi.com/the-ultimate-guide-to-the-datetime-datatypes for a good overview.

Upvotes: 10

Mark Ransom
Mark Ransom

Reputation: 308206

If you're unsure, use datetime - anything else is premature optimization. You might change your mind about needing seconds in the future.

Upvotes: 7

MartW
MartW

Reputation: 12538

If you don't care about seconds, dates earlier than 1900 or later than 2079, smalldatetime will be fine :) Otherwise you're better off with datetime.

http://msdn.microsoft.com/en-us/library/aa258277(SQL.80).aspx

Upvotes: 4

Related Questions