Following code will be helpful …. written in PHP
$result = mysql_query("SELECT * FROM students");
$row = mysql_fetch_row($result);
$adm_date = date_create($row[0]);
if(preg_match('@([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})@', $adm_date, $n)) {
$converted=$n[3]."https://stackoverflow.com/".$n[2]."https://stackoverflow.com/".$n[1];
echo $converted;
}