![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Contains the resulting string. Its syntax is V (variable-length character string).\ The format of the resulting string. Its syntax is C (fixed-length character string), UN (Unicode), or V.
• Only the date components explicitly mentioned in pic_string are converted.
• If pic_string is null the installation default is used.
Format Code One‑ or two‑digit week # (of year), with no leading 0. Two‑digit week # (of year). Two‑character quarter. Two‑digit century.
• A week is defined to begin on a Monday and end on the following Sunday. However, January 1 always begins week one, regardless of where it falls in the week, and week two starts on the following Monday.
You can specify just a portion of a date field within your mask (for example, entering only MMMM displays the month). Partial date occurrences cannot be accessed using a GET or FORALL statement, as the data cannot be interpreted as a complete date. At least the year portion of a date must be present in the mask to make it accessible to these statements.
Signalled if pic_string is not a string, or if date is not a date. Signalled if pic_string contains invalid characters, or if it is not in a valid date format.
1. Creates values with the string semantic type, for the field BIRTHDATE, in the format YY/MM/DD.
The format of the BIRTHDATE field in the table EMPLOYEE_DATE is illustrated here. It appears in the default date format for the installation.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |