Julian date and time functions
Date and Time fields.
!DATE
specifies the field has one of the date formats dd/mm/yy, dd/mm/ccyy,
dd-Mon-yy or dd-Mon-ccyy
and is to be converted into a Julian day
dd is a 1 or 2 digit day of the month, mm
a 1 or 2 digit month of the year, Mon is a three letter month name (
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
),
yy is the year within the century (00 to 99), cc is the century (19 or 20).
The separators '/' and '-' must be present as indicated.
The dates are converted to days since 1899.
When the century is not specified, yy of 0-32 is taken as 2000-2032, 33-99 taken as 1933-1999.
!DMY
specifies the field has one of the date formats
dd/mm/yy or dd/mm/ccyy
and is to be converted into a Julian day.
!MDY
the field has one of the date formats mm/dd/yy or mm/dd/ccyy
and is to be converted into a Julian day.
!TIME
specifies the field has one of the format
hh:mm:ss
and is to be converted into
seconds past midnight where
hh is hours (0 to 23), mm is minutes (0-59)
and ss is seconds (0 to 59). The separator ':' must be present as indicated.
Converting numeric date fields.
preceeding qualifiers apply when the date fields have
separators '/' or '-' in them. These qualifiers apply when
are no separators in the date field.
!Jddm
converts a
number presumed to be a date in the form
ddmmccyy, ddmmyy or ddmm into days.
!Jmmd
converts a date in
the form ccyymmdd, yymmdd or mmdd into days.
!Jyyd
converts a date in the form ccyyddd or yyddd into days.
These calculate the number of days since December 31 1899 and are
valid for dates from January 1 1900 to December 31 2099; note that
if cc is omitted it is taken as 19 if yy lt 33 and 20 if
yy | gt 32.
The date string must be entirely numeric: characters
such as '/' may not be present.
Back to transformation summary
Return to index
|