current_timestamp and default now()

From: "amy cheng" <amycq(at)hotmail(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: current_timestamp and default now()
Date: 1999-10-25 13:05:42
Message-ID: 19991025200542.7728.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, there,

I'm using:

create table test (
proposetime datetime not null default now(),
)

then, I find that I need to make the time uniform through the
transaction. Is there a way to use current_timestamp('now')
in the create table statement? Seems impossible?

thanks!!!!!!!

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 1999-10-25 13:16:48 Re: [GENERAL] Import data from a file
Previous Message Johann Höchtl 1999-10-25 12:54:09 time difference