New SQL Date and Time Data Types with SQL Server 2008

Microsoft SQL Server 2008 has introduced new SQL Server data types SQL Date and SQL Time for sql developers.

After Microsoft SQL Server 2008, t-sql developers are able to work with Date data types as well as Time data types. SQL programmers can now seperate the datetime data types to date and time data types.

If you execute the following sql script, you will see how new sql data types Date and Time can be used in your sql codes.

DECLARE @date_variable as date = GETDATE()
DECLARE @time_variable as time = GETDATE()

select @date_variable
2011-02-20
select @time_variable
23:57:33.4370000