Date Functions
Select date_function(parameter)
1. Dateadd (datepart,number,date): Adds the number of dateparts to the date Example
Select Dateadd (mm, 6, '1/1/01')-[ 2001-07-01] Select Dateadd (mm, -6, '1/1/01')-[ 2001-07-01]
2. Datediff (datepart,date1,date2): Number of dateparts between two dates Example
Select datediff(dd, '10/3/01', '10/9/01')
3. Getdate() :Returns current date and time in internal format Example
Select Getdate()
| Datepart | Abbreviation |
| Day | DD,D |
| Day of year | DY |
| Hour | HH |
| Millisecond | MS |
| Minute | MI |
| Month | MM,M |
| Quarter | QQ |
| Second | SS, S |
| Week | WK |
| Weekday | DW |
| Year | YY, YYYY |