Re: Re: Timestamp without time zone

You can't.

Docs are slightly misleading, timestamp _has_ timezone, the [with time
zone] syntax is only optional to explicitly specify that TZ is there.

At any case, I have never ran into a problem using timezone, and never
needed to 'strip it'. Since you probably never display bare output of
"select blah" anyway, but format the time in your own unique way, there
you can remove timezone.

Why do you _want_ to remove timezone from values in database? There is
definitely a way to work around whatever problem you are having.

On 14 Jun 2001, Vivek Khera wrote:

> >>>>> "PS" == Pasi Salminen <pasi(dot)salminen(at)khf(dot)fi> writes:
>
> PS> I am trying to create table with a field which type is timestamp
> PS> and I don't want it to be timestamp with time zone.
>
> This question has been asked at least 4 times since I've been
> following this list, including once by me.
>
> Appaarently, nobody seems to have an answer. The docs imply that type
> timstamp is without timezone, since there is a type "timestamp with
> timezone". If you do a "\d tablename" in psql, it shows "timestamp
> with timezone" on all your fields you declare as timestamp. This
> leads me to believe that they are silently "upgraded" in their type.
>
> I have a subroutine in my apps that strips the timezone before passing
> it along to the users.
>
>