Overview of SQL Server Data Types: Date and Time

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
1,537
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Dec 25, 2010

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

Category:

Science & Technology

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more