DATE and Integer Arithmetic
The following arithmetic functions can be performed with date and an integer (INTEGER is
interpreted as a number of days):
• DATE + INTEGER
• INTEGER + DATE
• DATE - INTEGER
These expressions are not processed as simple addition or subtraction, but rather as explained in the following process:
1 The encoded date value is converted to an intermediate value which is the number of days
since some system-defined fixed date.
2 The integer value is then added or subtracted, forming another value as number of days,
since the fixed base date.
3 The result is converted back to a date, valid in the Gregorian calendar.
Hello,
I am trying to create a measure in business objects using the formula: (order_date + pflt)
where the order_date is a normal date and the pflt is an integer column in teradata
When I try to add the pflt to the date field, I get the error: Invalid date supplied for dbname.pflt
sql used: select order_date + pflt as duedate from dbname.viewname;
Can someone please help me with this query?
Thanks in advance,
Divya