Re: SQL, Julian Date Conversion

> DAS, you responded with: >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. I am interested in copies of the two functions. Are they to big to send over the net? Can I ftp them from you? Thanks, Mark -------- 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 --------