Date and Time Operators

  • Article

The following operators act on dates and times.

Date and Time Operators

Operator Action Code 
+
 Addition 
tNewTime = tTime1 + nSeconds
dNewDate = dDate1 + nDays
 
-
 Subtraction 
nSeconds = tTime1 - tTime2
tNewTime = tTime1 - nSeconds
dNewDate = dDate1 - nDays

See Also

Date Data Type | DateTime Data Type | Date and Time Functions | Operators