Kay Man wrote:
>I would like to know how to retrieve current date and
>calculate date intervals. I tried the below but not
>work:
>
>1. SELECT CURRENT_DATE
SELECT DATE
>2. SELECT * FROM TABLE1
> WHERE (DATE1 < '2001-10-23'-INTERVAL '2 DAYS')
SAP DB does not have INTERVALS as such, often functions like
ADDDATE ( <date_or_timestamp_expression>, <expression> )
or SUBDATE ( <date_or_timestamp_expression>, <expression> )
or DATEDIFF ( <date_or_timestamp_expression>,
<date_or_timestamp_expression> )
(see reference manual --> basic concepts --> function --> date function)
can help.
Elke
SAP Labs Berlin
