From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
---|---|
To: | "Ing(dot) Roberto Andrade" <randrade(at)campus(dot)iztacala(dot)unam(dot)mx>, sql <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | RE: [SQL] Use of 'default TEXT now()' |
Date: | 1999-03-24 21:14:55 |
Message-ID: | D05EF808F2DFD211AE4A00105AA1B5D202691D@cpsmail.cpsgroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)campus(dot)iztacala(dot)unam(dot)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(at)campus(dot)iztacala(dot)unam(dot)mx
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Davis | 1999-03-24 21:18:16 | RE: [SQL] Comparing Dates to Current Time |
Previous Message | Jackson, DeJuan | 1999-03-24 21:12:19 | RE: [SQL] Comparing Dates to Current Time |