Received: from campus.campus.iztacala.unam.mx (campus.iztacala.unam.mx [132.248.79.80]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA74289 for ; Wed, 24 Mar 1999 15:16:29 -0500 (EST) (envelope-from randrade@campus.iztacala.unam.mx) Received: (from randrade@localhost) by campus.campus.iztacala.unam.mx (8.8.8+Sun/8.8.8) id OAA07829; Wed, 24 Mar 1999 14:19:59 -0600 (CST) Date: Wed, 24 Mar 1999 14:19:59 -0600 (CST) From: "Ing. Roberto Andrade" X-Sender: randrade@campus To: sql Subject: Use of 'default TEXT now()' Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id PAA74291 Hi: I'm writing an application where I have to use a datetime field. In this field we'll keep the date and time of the coments about some tasks. I am not sure about the right use of 'default', should I use: fecha_obs datetime default TEXT now() or fecha_obs datetime default now() ? When I must use TEXT ? I want to retrieve the fields in datetime order. TIA Roberto Andrade Fonseca Universidad Nacional Autónoma de México Teléfonos: 623-1154, 623-1119 e-mail: randrade@campus.iztacala.unam.mx