SQL Date Functions

Function	Description
AddMonths	Adds a number of Months to a date.
Current_date	Current machine date.
Current_time	Current machine time.
DateValue	Returns a date value for a date string.
Day	Returns the day value for a date.
DayOfWeek	Returns day of week for a Date, as a number from 1 to 7 numbering from Sunday as 1.
Extract	Extract year, month or day from a date.
MaxDate	Returns the maximum from the dates provided.
MinDate	Returns the minimum from the dates provided.
Month	Returns the month value for a date.
SystemDate	Returns the current System Date.
TimeValue	Returns a time value for a string.
WeekNo	Returns the week of the year a date occurs in.
Year	Returns the year value for a date.

Note: You can add or subtract numbers or other dates to Dates, using + or -.

In This Section