Folks,
Our databases stores most of the dates as timestamp
with timezone format, so the data looks like this...
09/12/2003 12:51:31.268 PDT
09/12/2003 12:50:20 PDT
some has centiseconds in them along with TZ. Now i'm
wondering is there a way to just extract date and
timestamp alone leaving the centisecods as well the TZ
part.
does pg_dump utility has any options to trunc this
while it exports data ?
cheers,
shankar
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com