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
Link to this comment:
All Comments (0)