Обсуждение: timestamp precision - can I control precision at select time or set for all time?
timestamp precision - can I control precision at select time or set for all time?
От
"mroyce@gmail.com"
Дата:
I have a database with several tables that use timestamp without time zone type. I upgraded from an older pgsql and have code that does not expect the precision in the select output. Is there a way I can get the effect of zero precision without modifying all the tables? The docs say it usees "default precision" as set in the "timestamp literal". I wasn't able to find docs describing what literals are. If there's a way I can set this to zero precision for everything, that'd save me a bunch of time. with thanks, Royce
"mroyce@gmail.com" wrote: > > I have a database with several tables that use timestamp without time > zone type. I upgraded from an older pgsql and have code that does not > expect the precision in the select output. Is there a way I can get the > effect of zero precision without modifying all the tables? > > The docs say it uses "default precision" as set in the "timestamp > literal". I wasn't able to find docs describing what literals are. If > there's a way I can set this to zero precision for everything, that'd > save me a bunch of time. > > with thanks, > Royce > I was facing the same obstacle. The only cure I've found was either SELECT CURRENT_TIMESTAMP ; timestamptz ------------------------------2005-03-22 09:43:51.05193+01 (1 row) SELECT CURRENT_TIMESTAMP::TIMESTAMP(0) ; timestamp ---------------------2005-03-22 09:44:11 (1 row) resp. change column types to TIMESTAMP(0) But I assume you've found this already by yourself. Regards, Christoph
thanks, christoph. i did go ahead and retool all the tables, but glad to know about the casting option.