SQL Tutorial - SQL DATE Functions like GETDATE, DATEADD, CONVERT

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,425
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 22, 2011

http://www.learningsqlserver2008.com/

GETDATE -- Today's date
DATEADD - adding time interval to an existing Date
DATEPART - return part of the date like year or month
DATEDIFF - Give you the different between two dates
DAY - returns the day of the month
MONTH - return the Month of the Year
YEAR - returns the year in the Sql expression
CAST - Converts an expression of one data type to another in SQL Server 2008 R2
CONVERT - Convert expressions of one data type to another in sql server r2
SQL Tutorial

  • 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