PowerCenter
- PowerCenter 10.5
- All Products
MAKE_DATE_TIME(year, month, day, hour, minute, second, nanosecond)
Argument
| Required/
Optional
| Description
|
---|---|---|
year
| Required
| Numeric datatype. Positive 4-digit integer. If you pass this function a 2-digit year, the
PowerCenter Integration Service returns “00” as the first two digits of the year.
|
month
| Required
| Numeric datatype. Positive integer between 1 and 12 (January=1 and December=12).
The Spark engine writes null values for rows when the month argument in the MAKE_DATE_TIME function passes an invalid value. In the native environment, the Data Integration Service rejects the row and does not write it to the target.
|
day
| Required
| Numeric datatype. Positive integer between 1 and 31 (except for the months that have less than 31 days: February, April, June, September, and November).
|
hour
| Optional
| Numeric datatype. Positive integer between 0 and 24 (where 0=12AM, 12=12PM, and 24 =12AM).
|
minute
| Optional
| Numeric datatype. Positive integer between 0 and 59.
|
second
| Optional
| Numeric datatype. Positive integer between 0 and 59.
|
nanosecond
| Optional
| Numeric datatype. Positive integer between 0 and 999,999,999.
|
MAKE_DATE_TIME( SALE_YEAR, SALE_MONTH, SALE_DAY, SALE_HOUR, SALE_MIN, SALE_SEC )
|
|
|
|
|
|
|
---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|