Re: Timestamp Column.

Posted in 1998

Mark D. Stock — Mon, 04 May 1998 14:13:33 +0200 — source: Informix-list mailing list archive (1991-1998)

ray_anderson@compusa.com wrote: > > There is not a timestamp designation, but you can add a 'DATE' field > and insert 'CURRENT YEAR TO SECOND'. > If you require greater accuracy then you can add 'FRACTIONS (3)'. I'm sure that was a simple typo, the data type is of course 'DATETIME'. Incidentally, FRACTION can store precision from 1 to 5 digits. The default is 3 digits. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+