If anyone knows the Ingres syntax for converting a Julian date to a date such as mm/dd/yyyy I would appreciate it.

Thank you.

The env variable II_DATE_FORMAT controls how dates are displayed in an Ingres DB - Have a look for that in the Ingres documentation and see if that answers your question.

I think this variable can be set for a single session, but be careful you don't change it across the entire installation (unless you want to of course)

Hi, are you using ABF ?

According to the webpage I just found, Julian dates are expressed in days since noon January 1, 4713 BC. Ingres has a couple of functions which relate to seconds since midnight Jan 1 1970 AD.

So if J is your julian date

SELECT _date((J-2440587.5)*86400), _time((J-2440587.5)*86400)

where 2440587.5 is the Julian date for 00:00 Jan 1 1970 and 86400 is secs/day

_date and _time always return the date according to GMT