RE: Julian date

Posted in 2005

Bill Dare — Thu, 9 Jun 2005 08:32:59 -0400 — source: Usenet: comp.databases.informix

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