Re: Now() function

On Jun 11, 2005, at 5:28 AM, David Siebert wrote:

> Quick question. can you set timestamptz to no fractional seconds?

The docs are very useful for things like this:
http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html

-------------
Name          timestamp [ (p) ]          timestamp [ (p) ]
                 [ without time zone ]      with time zone
Storage Size  8 bytes                    8 bytes
Description   both date and time         both date and time, with
time zone
Low Value     4713 BC                    4713 BC
High Value    5874897 AD                 5874897 AD
Resolution    1 microsecond / 14 digits  1 microsecond / 14 digits

<snip />

time, timestamp, and interval accept an optional precision value p
which specifies the number of fractional digits retained in the
seconds field. By default, there is no explicit bound on precision.
The allowed range of p is from 0 to 6 for the timestamp and interval
types.
-------------

Please always cc the list so others may be able to help, and please
don't top post.

Michael Glaesemann
grzm myrealbox com