Use of 'default TEXT now()' - Mailing list pgsql-sql

From Ing. Roberto Andrade
Subject Use of 'default TEXT now()'
Date
Msg-id Pine.SOL.3.91.990324141218.6717E-100000@campus
Whole thread Raw
Responses Re: [SQL] Use of 'default TEXT now()'  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Jenny DiBartolomeo
Date:
Subject: Comparing Dates to Current Time
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Comparing Dates to Current Time