Re: Re: [HOW TO:] timestamp WITHOUT timezone - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: [HOW TO:] timestamp WITHOUT timezone
Date
Msg-id 13801.996785073@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HOW TO:] timestamp WITHOUT timezone  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
Vivek Khera <khera@kcilink.com> writes:
> "CF" == Christophe Faizant <cfaizant@prisma-presse.com> writes:
> CF> I have the following problem with my postgresql "timestamp" type
> CF> field.  I don't wish to get a timezone attribute after the
> CF> timestamp, but each time I browsed rows via phppgadmin or via my
> CF> php pages, I've gotten an additional

> Timestamps always have timezone.  No way around it.  You need to alter
> your application to deal with it.

Not necessarily.  You could use a view that formats the timestamp the
way your application wants (see to_char()).

            regards, tom lane

pgsql-general by date:

Previous
From: "Vilson farias"
Date:
Subject: inittab X init.d
Next
From: "Jim Ballard"
Date:
Subject: Timestamp with time zone issue