skip to main content
SQL Statements for Flat-File Drivers : Select Statement : SQL Expressions : Date Operators
  
Date Operators
You can include the following operators in date expressions:
Operator
Meaning
+
Add a number of days to a date to produce a new date.
–
The number of days between two dates, or subtract a number of days from a date to produce a new date.
The following table shows examples of date expressions. In these examples, hire_date is {01/30/1990}.
Example
Resulting Value
hire_date + 5
{02/04/1990}
hire_date – {01/01/1990}
29
hire_date – 10
{01/20/1990}