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@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!