From: | Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: timestamp with timezone |
Date: | 2003-09-12 19:45:20 |
Message-ID: | bjt7nv$7qe$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)yahoo(dot)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(at)postgresql(dot)org
>
>
>
--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno(dot)leveque(at)net6d(dot)com
http://www.net6d.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dylan Milks | 2003-09-12 19:59:21 | Re: Casting varchar to bytea |
Previous Message | Ian Barwick | 2003-09-12 19:36:19 | Re: Casting varchar to bytea |