Re: SQL, Julian Date Conversion

Mark Elliott, in your mail you wrote: > > I am trying to use either Julian (YDDD) or Ordinal (YYDDD) dates in an > Informix-SQL 2.10 database. Informix does not recognize Julian dates but > does store the date as an integer representing the number of days since > December 31, 1899. Does anyone have a C function that will convert the > integer representation to the Julian/Ordinal format? > I have two well-commented C functions that mimic rstrdate() and rdatestr(). I bet you could easily tweek these functions to do what you want. BTW, rstrdate() changes "mm/dd/yyyy" to an internal format and rdatestr() does the opposite. DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com