use $date=("d/m/Y",strtotime(value_from_db));
strtotime will convert a string value to a timestamp.
Steve
> -----Original Message-----
> From: Sean Weissensee [mailto:[EMAIL PROTECTED]]
> Sent: 10 May 2001 11:13
> To: PHPDB
> Subject: [PHP-DB] Date formats from Postgres
>
>
>
> I am reading a data datatype from a PostgreSQL database,
>
> the format sohwing is 2001-01-05 for the 1st of May this year,
>
> I need this date in Australian format i.e. 01/05/2001,
>
> I tried using the string date (string format [, int timestamp])
>
> but with no success.I am not sure how to convert the database variable
> into
> a timestamp.
>
> any suggestions ?
>
> Sean Weissensee
>
> IT Manager
> Ion Solutions
>
> www.ionsol.com.au
>
--
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]