Dates in database + retrieving

[chocopi]

What is the best way to store dates into database so the data can be retrieved later on.

 

For example:

 

I use this to get the date and i store it.

<?php
$date = date('d/m/y');
?>

However, if i wanted it to say '20 March 2007' would this be easy or is there a better way to store them.

 

Cheers,

 

~ Chocopi

[MadTechie]

well i use TIME(); but everyone has their own way!

 

<?php
$nextWeek = time() + (7 * 24 * 60 * 60);
                   // 7 days; 24 hours; 60 mins; 60secs
echo 'Now:       '. date('Y-m-d') ."\n";
echo 'Next Week: '. date('Y-m-d', $nextWeek) ."\n";
// or using strtotime():
echo 'Next Week: '. date('Y-m-d', strtotime('+1 week')) ."\n";
?> 

[chocopi]

Is there an advantage of using time() over date() as i only used date as it seemed the most obvious

[spfoonnewb]

--Ignore--

[chocopi]

Cheers for that

 

Anyways, can you help with an array so when i have 20/05/2007 it says 20 May 2007

 

would it be like:

 

<?php
$month = array('','January','February','March','April','May','June','July','August','September','October','November','December');

	while($row = mysql_fetch_assoc($date))
		{
			$mon = $month[$row['date']];
		echo "The month is $mon\n";
		}
?>

[Barand]

Closing this post as you asked the same question (near as dammit, anyway) in another post - please don't double post.