[RESOLVED] Format Date Query

[obrienkev]

Hi all,

How do I convert the below into this format: 09/01/2006

Want to remove the time also. Thanks.

Jan 9 1900 5:20PM

[mrmigu]

try using this functiong to turn the date into a timestamp: http://ca3.php.net/manual/en/function.strtotime.php
and then use this to format the date to how you want it:
http://ca3.php.net/manual/en/function.date.php

if that doesnt work, you could split the date by spaces and then convert the month field into the corresponding number, and then insert /'s and the new values

[Houdini]

Just use this code (modified of course, but to test it out then use it for what you are wanting and mrmigu gave you a link to.

<?php 
// Users entry is below as $userdate just so you 
// can play with the function.
$userdate= "31 Jan 2006 5:20PM";
// Call the fix_date() function
fix_date($userdate);
function fix_date($my_date){
//First : Convert the date to time 
$my_time = strtotime($my_date); 
echo $my_time."<br>";
//To display it as day of month with no 0's use j
$newdate=date('j/m/Y',$my_time); 
echo date('j/m/y',$my_time); 
//This will give you your new date in your desired 
//format with no 5:20PM (or any time mention, just the date)
}
 ?> 

[bpat1434]

$newdate = date('m/d/Y', strtotime($olddate));

It's that easy....