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