| From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
|---|---|
| To: | Donald Fraser <demolish(at)cwgsy(dot)net> |
| Cc: | "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: timestamps |
| Date: | 2003-07-20 23:39:30 |
| Message-ID: | 3F1B2832.6030404@pse-consulting.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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.
Regards,
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-07-21 09:57:45 | Re: Error on most recent slackware build |
| Previous Message | Andreas Pflug | 2003-07-20 23:36:51 | Re: Error on most recent slackware build |