PowerCenter
- PowerCenter 10.5.1
- All Products
Condition
| Expression
| Return Value
|
---|---|---|
Month between January and June, function returns January 1 of the same year and sets the time to 00:00:00.000000000.
|
| 01/01/1998 00:00:00.000000000
|
Month between July and December, function returns January 1 of next year and sets the time to 00:00:00.000000000.
|
| 01/01/1999 00:00:00.000000000
|
Day of the month between 1 and 15, function returns the first day of the input month and sets the time to 00:00:00.000000000.
|
| 04/01/1998 00:00:00.000000000
|
Day of the month between 16 and the last day of the month, function returns the first day of the next month and sets the time to 00:00:00.000000000.
|
| 06/01/1998 00:00:00.000000000
|
Time between 00:00:00 (12 a.m.) and 11:59:59 a.m., function returns the current date and sets the time to 00:00:00.000000000 (12 a.m.).
|
| 06/13/1998 00:00:00.000000000
|
Time 12:00:00 (12 p.m.) or later, function rounds the date to the next day and sets the time to 00:00:00.000000000 (12 a.m.).
|
| 06/14/1998 00:00:00.000000000
|
Minute portion of time between 0 and 29 minutes, function returns the current hour and sets minutes, seconds, milliseconds, and nanoseconds to 0.
|
| 04/01/1998 11:00:00.000000000
|
Minute portion of the time 30 or greater, function returns the next hour and sets minutes, seconds, milliseconds, and nanoseconds to 0.
|
| 04/01/1998 14:00:00.000000000
|
Time between 0 and 29 seconds, function returns the current minute and sets seconds, milliseconds, and nanoseconds to 0.
|
| 05/22/1998 10:15:00.000000000
|
Time between 30 and 59 seconds, function returns the next minute and sets seconds, milliseconds, and nanoseconds to 0.
|
| 05/22/1998 10:16:00.000000000
|
Time between 0 and 499 milliseconds, function returns the current second and sets milliseconds to 0.
|
| 05/22/1998 10:15:29.000000000
|
Time between 500 and 999 milliseconds, function returns the next second and sets milliseconds to 0.
|
| 05/22/1998 10:15:30.000000000
|
Time between 0 and 499 microseconds, function returns the current millisecond and sets microseconds to 0.
|
| 05/22/1998 10:15:29.498000000
|
Time between 500 and 999 microseconds, function returns the next millisecond and sets microseconds to 0.
|
| 05/22/1998 10:15:29.499000000
|
Time between 0 and 499 nanoseconds, function returns the current microsecond and sets nanoseconds to 0.
|
| 05/22/1998 10:15:29.498125000
|
Time between 500 and 999 nanoseconds, function returns the next microsecond and sets nanoseconds to 0.
|
| 05/22/1998 10:15:29.498126000
|
ROUND(date[,format] )
Argument
| Required/
Optional
| Description
|
---|---|---|
date
| Required
| Date/Time datatype. You can nest TO_DATE to convert strings to dates before rounding.
|
format
| Optional
| Enter a valid format string. This is the portion of the date that you want to round. You can round only one portion of the date. If you omit the format string, the function rounds the date to the nearest day.
|
ROUND( DATE_SHIPPED, 'Y' ) ROUND( DATE_SHIPPED, 'YY' ) ROUND( DATE_SHIPPED, 'YYY' ) ROUND( DATE_SHIPPED, 'YYYY' )
|
|
---|---|
|
|
|
|
|
|
|
|
ROUND( DATE_SHIPPED, 'MM' ) ROUND( DATE_SHIPPED, 'MON' ) ROUND( DATE_SHIPPED, 'MONTH' )
|
|
---|---|
|
|
|
|
|
|
|
|
ROUND( DATE_SHIPPED, 'D' ) ROUND( DATE_SHIPPED, 'DD' ) ROUND( DATE_SHIPPED, 'DDD' ) ROUND( DATE_SHIPPED, 'DY' ) ROUND( DATE_SHIPPED, 'DAY' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
ROUND( DATE_SHIPPED, 'HH' ) ROUND( DATE_SHIPPED, 'HH12' ) ROUND( DATE_SHIPPED, 'HH24' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
ROUND( DATE_SHIPPED, 'MI' )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|