RE: Julian date

Posted in 2005

Dirk Moolman — Thu, 9 Jun 2005 16:12:57 +0200 — source: Usenet: comp.databases.informix

Excellent, thank you very much I also tried Google, but you beat me to it :-) -----Original Message----- From: Bill Dare [mailto:dareb@jevic.com] Sent: 09 June 2005 02:33 PM To: owner-informix-list@iiug.org; Dirk Moolman; informix-list@iiug.org Subject: RE: Julian date found this on google SELECT today - MDY(12,31,YEAR(today) - 1) AS day_of_year FROM systables where tabid = 1; Bill > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Dirk Moolman > Sent: Thursday, June 09, 2005 5:37 AM > To: informix-list@iiug.org > Subject: Julian date > > > How do I display a date in Julian format in Informix ? > > (I think the version is 9.21, if this makes a difference - for a > friend > of mine) > > > > > > > Dirk Moolman > Database and Unix Administrator > MxO Information Systems (HealthCorp) > > > > "People demand freedom of speech as a compensation for the freedom of > thought which they seldom use." > > > sending to informix-list sending to informix-list