The SMALLJUL2DATE function converts a small Julian date (YYDDD) into a date formatted as YYMMDD.
Category
Date / Time
Syntax
SMALLJUL2DATE(julian_date)
Parameter and Description
| Parameter | Description |
|---|---|
| julian_date | A five (5) digit small Julian date value in YYDDD format. |
Example
Convert the Julian day into a conventional date (YYMMDD format). Assume that the current year is 2005. Map the result to target field TGT_DATE.
TGT_DAT = SMALLJUL2DATE(05031)
Returns the value of 05031 and maps the result to the target field.