This video is part of LearnItFirst's Transact-SQL Programming: SQL Server 2008/R2 course. More information on this video and course is available here:
http://www.learnitfirst.com/Course/161/SQL-Programming-2008.aspx?an=YouTube
The temporal data types will be broken up in to two videos. Here, starting with the GETDATE function, trainer Scott Whigham walks you through using DATE, TIME, DATETIME, and SMALLDATETIME. You will see how many bytes of storage the different types use, how Management Studio rounds decimal places, and more.
Highlights from this video:
*The GETDATE function
*Are you able to isolate just the date or just the time from a DATETIME data type?
*DATETIME and SMALLDATETIME
and much more
Link to this comment:
All Comments (0)