Re: Date formats from Postgres
| From: | Alexey Borzov | Date: | Thu, 10 May 2001 10:14:05 +0000 |
| Subject: | Re: Date formats from Postgres | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9212@lists.php.net to get a copy of this message | ||
Greetings, Sean!
At 10.05.2001, 14:08, you wrote:
SW> I am reading a data datatype from a PostgreSQL database,
SW> the format sohwing is 2001-01-05 for the 1st of May this year,
Isn't it 2001-05-01?
SW> I need this date in Australian format i.e. 01/05/2001,
SW> I tried using the string date (string format [, int timestamp])
SW> but with no success.I am not sure how to convert the database variable into
SW> a timestamp.
SW> any suggestions ?
Well, you can either convert the date to UNIX timestamp using
date_part('epoch', <your field>)
in the query and then apply PHP's date to the result or convert
it directly to the required format using
to_char(<your field>, 'DD/MM/YYYY')
--
Yours, Alexey V. Borzov, Webmaster of RDW.ru