Fearpig Posted May 17, 2007 Share Posted May 17, 2007 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? Link to comment https://forums.phpfreaks.com/topic/51801-solved-date-formatting/ Share on other sites More sharing options...
jitesh Posted May 17, 2007 Share Posted May 17, 2007 <?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; ?> Link to comment https://forums.phpfreaks.com/topic/51801-solved-date-formatting/#findComment-255221 Share on other sites More sharing options...
Fearpig Posted May 17, 2007 Author Share Posted May 17, 2007 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! Link to comment https://forums.phpfreaks.com/topic/51801-solved-date-formatting/#findComment-255236 Share on other sites More sharing options...
Fearpig Posted May 17, 2007 Author Share Posted May 17, 2007 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. Link to comment https://forums.phpfreaks.com/topic/51801-solved-date-formatting/#findComment-255256 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.