Re: Handling timestampz datatype

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?

I use to_date() in the SQL to convert for display, and that works well.

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/ 
---------------------------------------------------------------------