Re: three timestamps/table, use of 'now' in table creation statement

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dennis Gearon <gearond(at)cvc(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: three timestamps/table, use of 'now' in table creation statement
Date: 2003-01-16 21:21:58
Message-ID: 20030116212158.GA27905@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 16, 2003 at 13:00:44 -0800,
Dennis Gearon <gearond(at)cvc(dot)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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brian Johnson 2003-01-16 21:51:30 Insert from CSV (comma separated values) file ?
Previous Message Tom Lane 2003-01-16 21:06:16 Re: Server error and deadlocks