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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to