Understanding ms sql server datetime type.?

Question

Why sql doesn't have different variable type for date and time because it is taugh to compare datetime colectively. Please write the link of any good tutorial of this topic.

Answer 1

You have to learn to use the data type. There is absolutely no problem there.

Answer 2

SQL Server has 6 different date and time datatypes, smalldatetime, datetime, datetime2, datetimeoffset, date, and time.



Each one has different accuracy from 100 nanoseconds to 1 day.

Answer 3

Their are dates, times, and datetimes. All three are different types. Sometimes you want to split the date and time components out, other times you don't.

Answer 4

Same reason they have smallint, int, float, etc. Different levels of precision are needed at different times...there's no need to store times down to the nanosecond if all you need is the date.