Contextual Ads
More PHP Resources
Advertisement
MySQL spits out date in YYYY-MM-DD format. The following code will show how we can customize the output.
First thing we need to do is to convert the DATE to TIME:
<?
//Im just starting with a date
$my_date = '2004-01-12';
//First : Convert the date to time
$my_time = strtotime($my_date);
?>
Yes, I have used the strtotime() function to convert the string $my_date to TIME. The strtotime() function will take an English date format and convert it to a UNIX timestamp.
Now that we have the TIME in $my_time, we can change the date output format to almost anything by using the DATE () function.
The following code will take the TIME in $my_time and display the date in YYYY-MM-DD format. [ This was the original format, but we are going to check if it really works ]
<?
//To display it as Y-m-d
echo date('Y-m-d',$my_time);
//This will give you 2004-01-12 (same as original)
?>
Note that we have used the DATE() function to convert the time to date.
Now if you would like to view the output as DD-MM-YYYY, use the following code
<?
//To display day-month-year
echo date('d-m-Y',$my_time);
//This will give you 12-01-2004
//To display the day, month spelled-out and Year
echo date("d , F Y", $my_time);
// This will give you 12 , January 2004
?>
This short tutorial was aimed to convert date to time and back to date in different formats. More information on PHP functions can be found at http://www.php.net |
Tutorials
Code
Knowledge Base
News
Forums
Pictures
Videos
Bargains
Icons
Newsgroups
PageRank™ Checker
Alexa Rank Checker
Domain-Name Lookup
(Rated 4.1 with 28 votes) 
Digg It!
Del.icio.us
Reddit
StumbleIt
Newsvine
Furl
BlinkList
Rate this tutorial
Current Comments
Bargains RSS Feed
View More Magazines
View More Downloads
