Connect CDC SQData

The SMALLJUL2DATE function converts a small Julian date (YYDDD) into a date formatted as YYMMDD.

Category

Date / Time

Syntax

SMALLJUL2DATE(julian_date)

 

Parameter Descriptions

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_DATE = SMALLJUL2DATE (05031)

 

Returns the value 050131 and maps the result to the target field.