RE: [PHP-DB] Date formats from Postgres
| From: | Steve Brett | Date: | Thu, 10 May 2001 10:13:11 +0000 |
| Subject: | RE: [PHP-DB] Date formats from Postgres | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9254@lists.php.net to get a copy of this message | ||
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:phpinfo@weissystems.com]
> 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
>