Member Avatar for lloydsbackyard

I have a date in a textbox ..
$myDate ='06/30/2014'

how do i convert it into this format..since this is the date format in the database..
$myDate ='2014-06-30'

thanks..

  • 3 Contributors
  • 3 Replies
  • 123 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by lloydsbackyard
Member Avatar for urtrivedi

We use explode fuction with seperator / , so it will give you array of size 3, then you can concate it as shown below

$datearr=explode("/",$myDate);
$dbdate=$datearr[2]."-".$datearr[0]."-".$datearr[1];
Member Avatar for DJBirdi

OR...

$dbDate = date('Y-m-j', strtotime($myDate));
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.