Before SQL 2008 there are 2 Datetime Data type to store Date and Time. These are:
- 1. DateTime
- 2. SmallDateTime
You cannot store Data and Time separately. You had to separate Date and Time using convert Function.
In SQL Server 2008 four new datetime data types are introduced: