Re: Re: [HOW TO:] timestamp WITHOUT timezone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [HOW TO:] timestamp WITHOUT timezone
Date: 2001-08-02 20:44:33
Message-ID: 13801.996785073@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vivek Khera <khera(at)kcilink(dot)com> writes:
> "CF" == Christophe Faizant <cfaizant(at)prisma-presse(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-02 21:04:03 Re: Points, Circles, Indexes, and query-by-Radius?
Previous Message Jim Ballard 2001-08-02 20:28:51 Timestamp with time zone issue