SQL, Julian Date Conversion

Posted in 1991

Mark Elliott — Wed, 7 Aug 91 14:20:43 PDT — source: Informix-list mailing list archive (1991-1998)

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? Thanks in advance -------- 2LT Mark G. Elliott Washington Army National Guard doma%uspfo.wa-ngnet.army.mil@wa-ngnet.army.mil Comm (206) 581-8235 DSN: 355-8235 --------