Re: Date format

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