Received: from bjke.com (firewall-user@ganymede.bjke.com [144.210.8.38]) by hub.org (8.9.2/8.9.1) with ESMTP id QAA80069 for ; Wed, 24 Mar 1999 16:14:38 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id PAA07675; Wed, 24 Mar 1999 15:14:32 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma007451; Wed, 24 Mar 99 15:14:21 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Wed, 24 Mar 1999 15:14:57 -0600 Message-ID: From: "Jackson, DeJuan" To: "Ing. Roberto Andrade" , sql Subject: RE: [SQL] Use of 'default TEXT now()' Date: Wed, 24 Mar 1999 15:14:55 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.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 QAA80073 Use: fecha_obs datetime default datetime(now()) The use of TEXT was for: fecha_obs datetime default text 'now' which will also do what you want (I believe, haven't tried it). -DEJ > -----Original Message----- > From: Ing. Roberto Andrade [mailto:randrade@campus.iztacala.unam.mx] > Sent: Wednesday, March 24, 1999 2:20 PM > To: sql > Subject: [SQL] Use of 'default TEXT now()' > > > 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 > >