Re: Timestamp Column.

Posted in 1998

Arun Shastry — 1 May 1998 17:37:42 GMT — source: Informix-list mailing list archive (1991-1998)

Create a column of type datetime year to second and insert CURRENT into it. Arun ray_anderson@compusa.com wrote in article <6icuv8$rmi$1@nnrp1.dejanews.com>... > 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)'. > > In article <6i6vdi$u7u$1@nnrp1.dejanews.com>#1/1, > pedrocr@dicoruna.es wrote: > > > > Hi all. > > > > I want to add a column of type timestamp in a table. (Informix Online 7.1) > > It's posible? > > In the manual i don't find the data type timestamp. > > Is there a type timestamp? > > How can i do? > > Please help. > > Thanks. > > > > Pedro Castelo. > > Diputacion Provincial de La Coru'a. > > Spain > > pedrocr@dicoruna.es > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > > http://www.dejanews.com/ Now offering spam-free web-based newsreading > > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading >