From: | will trillich <will(at)serensoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Format of timestamp field |
Date: | 2001-05-11 21:13:33 |
Message-ID: | 20010511161333.A18098@serensoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, May 09, 2001 at 02:26:22PM -0400, Natacha Joseph wrote:
> Hi,
>
> I used PostgreSQL 6.53 and I used tables with timestamps fields. When I
> read the value of a Timestamp field in a C program, i received a string of
> this format :
> 2001-04-08 12:54:09-0
> Can someone give me some explanation about the meaning of the two last
> characters ?
> Thanks
time zone (relative to gmt) -- i'm in central daylight, so mine
looks like this:
> select now();
now
------------------------
2001-05-11 16:12:04-05
(1 row)
> set time zone 'GMT';
SET VARIABLE
> select now();
now
------------------------
2001-05-11 21:12:15+00
(1 row)
gmt minus five hours = cdt
see /usr/share/doc/postgresql-doc/html/user/datatype1130.htm#AEN1607
--
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html
will(at)serensoft(dot)com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
From | Date | Subject | |
---|---|---|---|
Next Message | will trillich | 2001-05-11 21:18:38 | Re: Postgresql newbie username/password question |
Previous Message | Jeffrey Silberberg | 2001-05-11 20:49:02 | Re: Web Hosting That Supports PostgreSQL |