SQL Date operators

SQL DATE OPERATORS

Class

SQL Applications

Purpose

Date operators

Syntax

<expression1> operator <expression2>[ operator <expression3>…]

See Also

INSERT, SQL OPERATORS, SELECT, UPDATE

Description

Operators used with Date expressions and Date/Numeric expressions:

Operator	Expression1	Expression2	Operation
+	Date	Numeric	Adds the <expression2> number of days to the date and returns a date
-	Date	Numeric	Subtracts the <expression2> number of days from the date and returns a date
-	Date	Date	Returns a numeric signifying the number of days between the two dates. If <expression2> is later, a negative number is returned

Example

EXEC SQL
SELECT account_no, ord_date – rec_date as "Delivery Delay"
FROM accounts
ORDER BY account_no;

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer