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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]