RE: [PHP-DB] Date formats from Postgres

2001-05-11 Thread Steve Brett 

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]

Re: [PHP-DB] Date formats from Postgres

2001-05-10 Thread Alexey Borzov 

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', )
in the query and then apply PHP's date to the result or convert
it directly to the required format using
to_char(, 'DD/MM/')

-- 
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]