Re: three timestamps/table, use of 'now' in table creation statement - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: three timestamps/table, use of 'now' in table creation statement
Date
Msg-id 20030116212158.GA27905@wolff.to
Whole thread Raw
In response to three timestamps/table, use of 'now' in table creation statement  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
On Thu, Jan 16, 2003 at 13:00:44 -0800,
  Dennis Gearon <gearond@cvc.net> wrote:
> What would it be rounded to, for the sake of knowledge?
>
> I will change all my table defintions to timestamp(0). BTW, what is the default resolution? I'm am
> in the process of RTFM'ing, don't worry.

I was just pointing out that there might be a difference between the two
cases. If you don't care about rounding, you can just use current_timestamp
instead of current_timestamp(0).

pgsql-general by date:

Previous
From: "Orr, Steve"
Date:
Subject: Re: Server error and deadlocks
Next
From: Tom Lane
Date:
Subject: Re: Server error and deadlocks