Date formats from Postgres
| From: | Steve Brett | Date: | Thu, 10 May 2001 12:08:42 +0000 |
| Subject: | Date formats from Postgres | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9255@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
>
Steve Brett
Internal Development
tel: 4251
EMIS Ltd.
"Privileged and /or Confidential information may be contained in this
message. If you are not the original addressee indicated in this message (or
responsible for delivery of the message to such person), you may not copy or
deliver this message to anyone. In such case, please delete this message,
and notify us immediately. Opinions, conclusions and other information
expressed in this message are not given or endorsed by my firm or employer
unless otherwise indicated by an authorised representative independently of
this message."
Egton Medical Information Systems Limited. Registered in England. No
2117205.
Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth,
Leeds, LS18 4RF