Date functions: Sql Server- DATEPART() , DATEADD() , DATEDIFF() , DATENAME() , DAY() , MONTH() ,YEAR()

V Useful sql date functions:

1. DATEPART()
2. DATEADD()
3. DATEDIFF()
4. DATENAME()
5. DAY()
6. MONTH()
7. YEAR()

http://shawpnendu.blogspot.in/2009/05/datepart-dateadd-datediff-sql-server.html

http://www.mssqltips.com/sqlservertip/2507/determine-sql-server-date-and-time-with-datepart-and-datename-functions/