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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
