1 - Insert date and time in place of timestamp
2 - use some functions like substring. Something like :
select substring('09/12/2003 12:51:31.268 PDT' from '../../.... ..:..:..')Bruno
Shankar K wrote:
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]
-- Bruno LEVEQUE System Engineer SARL NET6D [EMAIL PROTECTED] http://www.net6d.com
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
