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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: [HOW TO:] timestamp WITHOUT timezone
Дата
Msg-id 13801.996785073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HOW TO:] timestamp WITHOUT timezone  (Vivek Khera <khera@kcilink.com>)
Список 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 по дате отправления:

Предыдущее
От: "Vilson farias"
Дата:
Сообщение: inittab X init.d
Следующее
От: "Jim Ballard"
Дата:
Сообщение: Timestamp with time zone issue