Thread: RE: [SQL] Use of 'default TEXT now()'

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

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