Thread: Format of timestamp field
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 Natacha Joseph njoseph@minacom.com
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!