PowerCenter
- PowerCenter 10.5
- All Products
Format String
| Description
|
---|---|
AM, a.m., PM, p.m.
| Meridian indicator. Use any of these format strings to specify AM and PM hours. AM and PM return the same values as do a.m. and p.m.
|
DAY
| Name of day, including up to nine characters (for example, Wednesday). The DAY format string is not case sensitive.
|
DD
| Day of month (1-31).
|
DDD
| Day of year (001-366, including leap years).
|
DY
| Abbreviated three-character name for a day (for example, Wed). The DY format string is not case sensitive.
|
HH, HH12
| Hour of day (1-12).
|
HH24
| Hour of day (0-23), where 0 is 12AM (midnight).
|
J
| Modified Julian Day. Convert strings in MJD format to date values. It ignores the time component of the source string, assigning all dates the time of 00:00:00.000000000. For example, the expression TO_DATE(‘2451544’, ‘J’) converts 2451544 to Dec 31 1999 00:00:00.000000000.
|
MI
| Minutes (0-59).
|
MM
| Month (1-12).
|
MONTH
| Name of month, including up to nine characters (for example, August). Case does not matter.
|
MON
| Abbreviated three-character name for a month (for example, Aug). Case does not matter.
|
MS
| Milliseconds (0-999).
|
NS
| Nanoseconds (0-999999999).
|
RR
| Four-digit year (for example, 1998, 2034). Use when source strings include two-digit years. Use with TO_DATE to convert two-digit years to four-digit years.
|
SS
| Seconds (0-59).
|
SSSSS
| Seconds since midnight. When you use SSSSS in a TO_DATE expression, the
PowerCenter Integration Service only evaluates the time portion of a date.
For example, the expression TO_DATE( DATE_STR, ‘MM/DD/YYYY SSSSS’) converts 12/31/1999 3783 to 12/31/1999 01:02:03.
|
US
| Microseconds (0-999999).
|
Y
| The current year on the node running the
PowerCenter Integration Service with the last digit of the year replaced with the string value.
|
YY
| The current year on the node running the
PowerCenter Integration Service with the last two digits of the year replaced with the string value.
|
YYY
| The current year on the node running the
PowerCenter Integration Service with the last three digits of the year replaced with the string value.
|
YYYY
| Four digits of a year. Do not use this format string if you are passing two-digit years. Use the RR or YY format string instead.
|