On Jul 31, 2006, at 14:23 , Dylan Fogarty-MacDonald wrote:
> I am using PG 7.3.4.
I strongly recommend upgrading, if not to the latest 8.1.4, then to
the most recent release of 7.3.15. These include patches to security
flaws and data-loss-incurring bugs. 8.1.4 will most likely perform
much better for you as well.
> if to_date() converts a string to date, what converts/formats date
> to string?
I think you'll want to look at TO_CHAR:
http://www.postgresql.org/docs/current/interactive/functions-
formatting.html
I've found it useful to use EXTRACT(EPOCH FROM your_timestamp) to
pass the timestamp to PHP, and then use the PHP timestamp formating
functions.
http://www.postgresql.org/docs/current/interactive/functions-
datetime.html#FUNCTIONS-DATETIME-EXTRACT
Hope this helps.
Michael Glaesemann
grzm seespotcode net