Re: Julian date conversion

Posted in 1994

Bob Baskett — 10 Mar 1994 20:53:04 -0500 — source: Informix-list mailing list archive (1991-1998)

karl, try the following, assumes that the julian date is stored as char(5): update {TABLENAME} set (column_name) =(date(MDY(01,01,1900+column_name[1,2])+(column_name[3,5]-1) units day)) ; regards, +----------------------------------------------------------------------------+ | . . | | | ... ... | Bob Baskett | | ..... ..... | Software Engineer, DBA | | .. ... .. | Business Systems Integration Group | | . . . | Semiconductor Products Sector | | | Mesa, AZ | | Motorola, Inc. | | +----------------------------------------------------------------------------+