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