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
>
>
