sql convert date dd/mm/yyyy code example

Example 1: php date format dd/mm/yyyy

date("d/m/Y", strtotime($str));

Example 2: php convert date from dd/mm/yyyy to yyyy-mm-dd

$date = DateTime::createFromFormat('d/m/Y', "24/04/2012");
echo $date->format('Y-m-d');

Example 3: sql server convert string to date

Cast( '2011-07-07' as date ) as convertedDate