[SOLVED] Date Formatting

[Fearpig]

Hi Guys,

I need pointing in the right direction on this one!

 

I have a table with a datetime field which is in the format "2007-06-20 00:00:00.000" using the following code I can display this nicely as dd/mm/yyyy (e.g. 20/06/2007).

 

<?php 

$Format_Start_Date = ($Start_Date != '')?date("d/m/Y",strtotime($Start_Date)):'';

?>

 

My question is this.... I now want to be able to edit these values by updating a form and I want the users to be able to enter the date in the format dd/mm/yyyy, can I edit the field so that it reads and updates as dd/mm/yyyy or alternately how would I convert the entry back to yyyy-mm-dd hh:mm:ss for the database to be updated?

 

 

[jitesh]

<?php
$date_p = "12/05/2007 12:12:50";
$date_arr = explode(" ",$date_p);
$date = explode("/",$date_arr[0]);

$date_f = $date[2]."-".$date[1]."-".$date[0]." ".$date_arr[1];
echo $date_f;
?>

[Fearpig]

thanks jitesh that's got me well on the way. There are still a few tweaks I need to do though. Can you recommend a good tutorial/explanation though as I’m not sure whats going on here!

[Fearpig]

Ignore my last post, I have just sat down and read the code properly and figured it all out. Very simple if you actually read it! Thanks again jitesh.