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:
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
Hope this helps.
grzm seespotcode net
In response to
- Date format at 2006-07-31 05:23:26 from Dylan Fogarty-MacDonald
pgsql-novice by date
|Next:||From: Michael Glaesemann||Date: 2006-07-31 05:41:24|
|Subject: Re: Date format|
|Previous:||From: Dylan Fogarty-MacDonald||Date: 2006-07-31 05:23:26|
|Subject: Date format|