Subtracts a specified time interval from a date.
Sample usage
DATETIME_SUB(Order Date, INTERVAL 1 WEEK)
Syntax
DATETIME_SUB(datetime_expression, INTERVAL integer part)
Parameters
datetime_expression
- a Date or a Date & Time field or expression.integer
- a whole numeric field or expression representing the number of parts to subtract.part
- the unit of time measurement to subtract. DATETIME_ADD supports the following values forpart
:MICROSECOND
: available for Date & Time fields or expressions.MILLISECOND
: available for Date & Time fields or expressions.SECOND
: available for Date & Time fields or expressions.MINUTE
: available for Date & Time fields or expressions.HOUR
: available for Date & Time fields or expressions.DAY
WEEK
. Equivalent to 7DAY
s.MONTH
QUARTER
YEAR
Return data type
Date & Time
Examples
Formula | Result |
DATETIME_SUB(DATETIME "2008-12-25 15:30:00", INTERVAL 10 MINUTE) |
2008-12-25 15:20:00 |
|
2008-12-20 |
Notes
This function is not available for compatibility mode date types.
Special handling is required for MONTH, QUARTER, and YEAR parts when the date is at (or near) the last day of the month. If the resulting month has fewer days than the original Date or Date & Time's day, then the result day is the last day of the new month.