Re: Timestamp Column.
Posted in 1998
Topics: Data Types & Schema Design
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