Thanks for your reply, Martijn. And see below. > On Sun, Apr 09, 2006 at 12:07:50PM -0800, Wei Wei wrote: > > I try to understand how the D&T information is stored/presented > > in PG. In the application, the data is reported as > > > > Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time > > > > But, in the DB, it is stated as > > > > 2006-04-09 14:40:53.093-07 > > > > It doesn't seen right to me. Both are on the same box and the > > date column is with time zone. > > Read the docs for the exact details but the gist of it is that > PostgreSQL always displays dates to you in your own timezone (or > whatever is configured with "set timezone" anyway). > I already read the document. But, I haven't found any related information.
> timestamp with timezone represents an instant in time, which may appear > as different actual values depending on which timezone you're talking > about. > I am not sure that I can follow you above. Someone told me that the timezone is always set as what it is with DB regardless the application nor the user choice. > timestamp without timezone is a timestamp that appears the same to > everyone, all the time. The uses for this are not entirely clear, given > you can't represent the overlaps or gaps created by daylight savings > shifts. However, sometimes this is what you want. > It doesn't seem to be the way as you describe above. Before the Summer Saving Time, the all timestamp with time zone data shown in the DB with "-8" ending. After the SST, they are shown with "-7" ending. -- _______________________________________________ Search for businesses by name, location, or phone number. -Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
