Change mysql date type into another date format with mysql’s date_format function

Posted by Shek on April 12, 2011 under MySQL | Be the First to Comment

MySQL’s date field type default is in yyyy-mm-dd format, and it is not practical in some cases when we want to use another formating representation such as dd/mm/yyyy. Of course we could use PHP to convert it but the best way I find is to convert it through SQL before any php operation, here is an example which I which like to show you:
Read more of this article »

Display the date with PHP

Posted by Shek on April 12, 2008 under PHP | Be the First to Comment

Editor’s note:¬†I recently worked on a web project which I need to add the date on a page. I used the PHP function¬†date( ) to accomplish the job. Here are my examples for your reference.

Read more of this article »