Microsoft Office Access
| Function Name | Description |
|---|---|
| CDate(<expression>) | Converts the expression to a date value. |
| Date | Obtains the current date value. |
| DateAdd(<interval>, <number>, <expression>) | Adds the specified number of the interval to the date or Date/Time expression. |
| DateDiff(<interval>, <expression1>, <expression2>, <firstdayofweek>, <firstdayofyear>) | Returns the specified number of intervals between the Date/Time in expression1 and the Date/Time in expression2. You can optionally specify a first day of the week other than Sunday and a first week of the year to start on January 1, the first week that has at least four days, or the first full week. |
| DatePart(<interval>, <expression>, <firstdayofweek>, <firstdayofyear>) | Extracts the part of the date or ... |
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
