Re: [PHP] Date format question

[Manisha Sathe]

Thanks to all, it help me a lot

manisha

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Date format question

[Manisha Sathe]

I have a date returned from MySQL in '-MM-DD' format, i want to show
this date in 'DD/MM/' 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Date format question

[John W. Holmes]

Manisha Sathe wrote:
I have a date returned from MySQL in '-MM-DD' format, i want to show
this date in 'DD/MM/' 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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Date format question

[Justin French]

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

I have a date returned from MySQL in '-MM-DD' format, i want to 
show
this date in 'DD/MM/' 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

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php