hallo,
kann mir jemand sagen wie man diesen string 2010-07-15 in 15.07.2010 umwandelt?
kann mir jemand sagen wie man diesen string 2010-07-15 in 15.07.2010 umwandelt?
$sql = "SELECT unix_timestamp(datum) datum AS dat_tmj FROM tabelle";
$new = date("d.m.y",strtotime('2010-07-15'));
$sql = "SELECT unix_timestamp(datum) datum AS dat_tmj FROM tabelle";
$sql = "SELECT unix_timestamp(datum) datum AS dat_tmj FROM tabelle";
// a)
$sql = "SELECT DATE_FORMAT(datum,'%d.%m.%Y') AS datum_tmj FROM tbl WHERE id=1";
$erg = mysql_query($sql);
$row = mysql_fetch_assoc($erg);
$datum_tmj = $row['datum_tmj'];
// b)
$sql = "SELECT UNIX_TIMESTAMP(datum) AS ts FROM tbl WHERE id=1";
$erg = mysql_query($sql);
$row = mysql_fetch_assoc($erg);
$datum_tmj = date('t.m.Y',$row['ts']);
// c)
$sql = "SELECT datum FROM tbl WHERE id=1";
$erg = mysql_query($sql);
$row = mysql_fetch_assoc($erg);
$datum_tmj = date('t.m.Y',strtotime($row['datum']));
// d)
$sql = "SELECT datum FROM tbl WHERE id=1";
$erg = mysql_query($sql);
$row = mysql_fetch_assoc($erg);
$datum = $row['datum_tmj'];
$datum_tmj = substr($datum,8,2) . '.' . substr($datum,4,2) . '.' . substr($datum,0,4);
Kommentar