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