John Siracusa wrote:
On 1/5/04 4:29 PM, Michael Glaesemann wrote:
(If you're not the John Siracusa who writes for Ars Technica, the
sentiment still holds. :) )
I am everywhere!
(worked, thanks to both of you who replied :)
Anyway the two solution solve different problems:
1) DEFAULT now()
How can I create a non-null date column that defaults to 'now' as computed
at the time the row is inserted?
-John
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to
On Mon, 2004-01-05 at 21:00, John Siracusa wrote:
How can I create a non-null date column that defaults to 'now' as computed
at the time the row is inserted?
The default should be either CURRENT_DATE or timeofday()::DATE
The difference is that CURRENT_TIME, CURRENT_TIMESTAMP and CURRENT_DATE
Hi John!
On Jan 5, 2004, at 3:00 PM, John Siracusa wrote:
How can I create a non-null date column that defaults to 'now' as
computed
at the time the row is inserted?
How about this?
test=# create table johns (comment text not null,this_time timestamp
not null default now(), this_date date not
On 1/5/04 4:29 PM, Michael Glaesemann wrote:
(If you're not the John Siracusa who writes for Ars Technica, the
sentiment still holds. :) )
I am everywhere!
(worked, thanks to both of you who replied :)
-John
---(end of broadcast)---
TIP 3: if