RE: datetime fields

Posted in 1997

BALLENTINE.MIKE@heb.com — 13 May 1997 09:58:10 -0400 — source: Informix-list mailing list archive (1991-1998)

This information may be found in the SQL Reference Guide ( page 2-13 for the 5.X version ) where the system catalogs are described. For instance, collength for a decimal column is (precision * 256 ) + scale. Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Tuesday, 13 May 1997 3:16am From: Silvester_Valiente@tnt.com.au Date:Tue, 13 May 1997 01:39:51 -0500 Subject: RE: datetime fields Mime-Version: 1.0 To: informix-list@rmy.emory.edu Content-Type: text/plain; charset=US-ASCII; name="RE: datetime fields" Content-Transfer-Encoding: 7bit Sender: informix-list-owner@rmy.emory.edu Reply-To: Silvester_Valiente@tnt.com.au 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. TIA Silvester Valiente Informix/Ingres DBA TNT Australia