On Tue, Feb 14, 2006 at 02:43:05PM -0800, CSN wrote: > I have a bunch of timestamps like: > > 2005-11-20 20:45:48.281653-07 > > How can I change it so they never get saved with > seconds fractions? You could set the fields to be of type TIMESTAMP(0) WITH TIME ZONE. Cheers, D -- David Fetter david@xxxxxxxxxx http://fetter.org/ phone: +1 415 235 3778 Remember to vote!