RE: datetime fields

Posted in 1997

Jonathan Leffler — 13 May 1997 11:48:06 -0400 — source: Informix-list mailing list archive (1991-1998)

I think it is covered in the FAQ (http://www.iiug.org). I also posted a program, SQLCMD, a month or so ago which contains code to deal with DATETIME and INTERVAL (and DECIMAL) decoding. Most of the info you need is cryptically available in datetime.h. You could also check the rtypname() function, but I don't think it gives the qualifiers which are the interesting part. If you really can't get at the archives, I can send you the sqltype.ec file which is part of SQLCMD. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: Silvester_Valiente@tnt.com.au >Date: Tue, 13 May 97 16:39:51 +1000 >X-Informix-List-Id: <list.14481> > >Has anyone had any experience converting a datetime field that is stored >in the syscolumns table to human readable form. > >ie in syscolumns the collength field stores the length of column. For a >datetime, this value is coded. For instance a datetime of year to minutes >equals 3080. > >I am trying to write a utility that will convert this value back to the text of >year to minutes.