----- Original Message ----- From: "Andreas Pflug" <[EMAIL PROTECTED]> To: "Donald Fraser" <[EMAIL PROTECTED]> Cc: "[pgADMIN]" <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 12:39 AM Subject: Re: [pgadmin-support] timestamps
> Donald Fraser wrote: > > > pgAdmin III July 16th > > > > I noticed a change in the display of "timestamp" data types. > > Most of my timestamp columns are defined as: "timestamp (0) without > > time zone" > > For a while pgAdmin III displayed this as "timestamp (-4)" but now > > it displays as "timestamp (0)", which is a step forward. > > > > My question: is it planned for pgAdmin III to be displaying timestamps > > correctly with respect to time zones? > > > > Regards > > Donald Fraser. > > > > PostgreSQL's official name is just timestamp(0), "without time zone" is > just decoration that's removed on creation. > with timezone is called timestamptz. > These type names are read from internal PostgreSQLs tables. timestamp didn't use to work that way, but having now read the latest documentation I note the following: "Note: Prior to PostgreSQL 7.3, writing just timestamp was equivalent to timestamp with time zone. This was changed for SQL spec compliance" Thanks for clearing that one up. Regards Donald Fraser. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
