Re: timestamp no fractional seconds

From: Scott Bailey <artacus(at)comcast(dot)net>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamp no fractional seconds
Date: 2009-06-03 05:44:02
Message-ID: 4A260DA2.5090509@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grzegorz Jaśkiewicz wrote:
> what difference does the (0) make than ? is timestamp() a function than ?/
>
The (0) is setting the precision. Telling it to store 0 places for the
fractional second. Much like setting scale and precision with numeric(6,2)

Scott

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2009-06-03 06:32:46 Evil Nested Loops
Previous Message Carlos Oliva 2009-06-03 02:08:29 Re: Schema, databse, or tables in different system folder