Re: timestamp with timezone - Mailing list pgsql-admin

From Bruno LEVEQUE
Subject Re: timestamp with timezone
Date
Msg-id bjt7nv$7qe$1@news.hub.org
Whole thread Raw
In response to Re: timestamp with timezone  (Shankar K <shan0075@yahoo.com>)
List pgsql-admin
I think you could choose between two solutions (at least) :

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 <shan0075@yahoo.com> 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 majordomo@postgresql.org
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com


pgsql-admin by date:

Previous
From: "Roberson, Dusty (L:ops Unix Admin)"
Date:
Subject: Configure complaints: Installed libs/apps not found
Next
From: Ben Kim
Date:
Subject: clarification