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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
