oops forgot to mention, database version is 7.3.2 --- Shankar K <[EMAIL PROTECTED]> wrote: > 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 >
__________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
