JULDAT: Converting From Gregorian to Julian Format

The JULDAT function converts a date from Gregorian format (year-month-day) to Julian format (year-number_of_the_day). A date in Julian format is a five- or seven-digit number. The first two or four digits are the year; the last three digits are the number of the day, counting from January 1. For example, January 1, 1999 in Julian format is either 99001 or 1999001.

Syntax: How to Convert From Gregorian to Julian Format

JULDAT(indate, output_format)

where:

indate

I6, I8, I6YMD or I8YYMD

Is the legacy date to convert.

output_format

I5 or I7

Top of page

Example: Converting From Gregorian to Julian Format

JULDAT converts the HIRE_DATE field to Julian format. It determines the century using the default DEFCENT and YRTHRESH parameter settings. The result is stored in a column with the format I7.

JULDAT(HIRE_DATE, 'I7')

For 82/08/01, the result is 1982213.

For 82/01/04, the result is 1982004.