Date format question

I have a date returned from MySQL in 'YYYY-MM-DD' format, i want to show
this date in 'DD/MM/YYYY' format using PHP, date() function does the same if
i pass timestamp in int format, but how to convert into int timestamp ?

e.g from '2003-11-25' to '20031125' ? and
Then I believe that i can use date ("d/m/Y", '20031125' ) to the things done
?

Thanks in advance,

regards,
manisha

Manisha Sathe wrote:
> I have a date returned from MySQL in 'YYYY-MM-DD' format, i want to show
> this date in 'DD/MM/YYYY' format using PHP, date() function does the same if
> i pass timestamp in int format, but how to convert into int timestamp ?
>
> e.g from '2003-11-25' to '20031125' ? and
> Then I believe that i can use date ("d/m/Y", '20031125' ) to the things done
> ?

No, date() expects a unix timestamp. You can either use

SELECT UNIX_TIMESTAMP(your_column) AS foo FROM Table ...

and then use the value in column 'foo' in date(), or just use
DATE_FORMAT() in your query to retrieve the row already formatted.

--
---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

On Tuesday, November 25, 2003, at 01:42 PM, Manisha Sathe wrote:

> I have a date returned from MySQL in 'YYYY-MM-DD' format, i want to
> show
> this date in 'DD/MM/YYYY' format using PHP, date() function does the
> same if
> i pass timestamp in int format, but how to convert into int timestamp
> ?
>
> e.g from '2003-11-25' to '20031125' ? and
> Then I believe that i can use date ("d/m/Y", '20031125' ) to the
> things done
> ?


<?
// the original
$mysql_date = '2003-11-25';

// convert to a unix timestamp (seconds since 1970)
$mysql_date_stamp = strtotime($mysql_date);

// pass $mysql_date_stamp to date() as 2nd parameter
$human_date = date('d/m/Y',$mysql_date_stamp);

echo $human_date;
?>

or simplified:

<?
$original = '2003-11-25';
echo date('d/m/Y', strtotime($original));
?>

Justin French

Thanks to all, it help me a lot

manisha