Re: Handling timestampz datatype

Поиск
Список
Период
Сортировка
От Andrew McMillan
Тема Re: Handling timestampz datatype
Дата
Msg-id 1036613108.20147.27.camel@kant.mcmillan.net.nz
обсуждение исходный текст
Ответ на Handling timestampz datatype  ("David Busby" <busby@pnts.com>)
Список pgsql-php
On Thu, 2002-11-07 at 07:08, David Busby wrote:
> List,
>     How are you all dealing with the timestampz data type in your PG/PHP
> applications?  I cannot seem to find the reliable way to deal with them (for
> display purposes).  My timestampz column comes into my PHP script as a text
> string, I have to convert (using strtotime()) first then use strftime() to
> format it.  Any ideas on the easy way to do this?

Woops :-)

I mean "to_char()"  :-)

Cheers,
                    Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------


В списке pgsql-php по дате отправления:

Предыдущее
От: "Michael Upchurch"
Дата:
Сообщение: Re: Spaawn another process
Следующее
От: "YC Nyon"
Дата:
Сообщение: Can't seem to get Psql and Exec to work together