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