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 RAA88124 for ; Wed, 24 Mar 1999 17:00:15 -0500 (EST) (envelope-from djackson@cpsgroup.com) Received: by bjke.com; id QAA13796; Wed, 24 Mar 1999 16:00:13 -0600 (CST) Received: from unknown(144.210.12.10) by gauntlet.bjke.com via smap (4.1) id xma013317; Wed, 24 Mar 99 15:59:23 -0600 Received: by cpsmail.cpsgroup.com with Internet Mail Service (5.5.2448.0) id ; Wed, 24 Mar 1999 15:59:59 -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:59:52 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" You might take a look at the tutorial on the PostgreSQL web-site (http://www.postgreSQL.ORG/docs/tutorial/index.html). There are other references under the "Getting Help/Documentation" section in the web-site as well > -----Original Message----- > From: Ing. Roberto Andrade [mailto:randrade@campus.iztacala.unam.mx] > Sent: Wednesday, March 24, 1999 3:32 PM > To: sql > Subject: RE: [SQL] Use of 'default TEXT now()' > > > Hi Jackson: > > On Wed, 24 Mar 1999, Jackson, DeJuan wrote: > > > 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 > > Where can I get some help about this subject? > > TIA, > > Roberto Andrade Fonseca >