PowerCenter
- PowerCenter 10.5.1
- All Products
ADD_TO_DATE ( SHIP_DATE, 'YY', 10 )
ADD_TO_DATE( SHIP_DATE, 'MONTH', -10 )
ADD_TO_DATE( SHIP_DATE, 'DD', 10 )
ADD_TO_DATE( SHIP_DATE, 'HH', 14 )
ADD_TO_DATE( SHIP_DATE, 'MI', 25 )
ADD_TO_DATE( SHIP_DATE, 'SS', 59 )
ADD_TO_DATE( SHIP_DATE, 'MS', 125 )
ADD_TO_DATE( SHIP_DATE, 'US', 2000 )
ADD_TO_DATE( SHIP_DATE, 'NS', 3000000 )
ADD_TO_DATE(date,format,amount)
Argument
| Required/
Optional
| Description
|
---|---|---|
date
| Required
| Date/Time datatype. Passes the values you want to change. You can enter any valid transformation expression.
|
format
| Required
| A format string specifying the portion of the date value you want to change. Enclose the format string within single quotation marks, for example, 'mm'. The format string is not case sensitive.
|
amount
| Required
| An integer value specifying the amount of years, months, days, hours, and so on by which you want to change the date value. You can enter any valid transformation expression that evaluates to an integer.
|
ADD_TO_DATE( DATE_SHIPPED, 'MM', 1 ) ADD_TO_DATE( DATE_SHIPPED, 'MON', 1 ) ADD_TO_DATE( DATE_SHIPPED, 'MONTH', 1 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
ADD_TO_DATE( DATE_SHIPPED, 'D', -10 ) ADD_TO_DATE( DATE_SHIPPED, 'DD', -10 ) ADD_TO_DATE( DATE_SHIPPED, 'DDD', -10 ) ADD_TO_DATE( DATE_SHIPPED, 'DY', -10 ) ADD_TO_DATE( DATE_SHIPPED, 'DAY', -10 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
ADD_TO_DATE( DATE_SHIPPED, 'HH', -15 ) ADD_TO_DATE( DATE_SHIPPED, 'HH12', -15 ) ADD_TO_DATE( DATE_SHIPPED, 'HH24', -15 )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|