Re: Data / Time problem

From: Date: Thu, 16 Nov 2000 07:50:13 +0000
Subject: Re: Data / Time problem
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-4461@lists.php.net to get a copy of this message
But, have any way is better ? ""Sam Masiello"" <smasiello@chekinc.com> ????? news:NEBBKELNALEOFHLEKLEKMEBJDOAA.smasiello@chekinc.com... > > If you know that the date returned in $fromMysql is a date in YYYYMMDD > format, why not just do something like this: > > $year = substr($fromMysql, 0, 4) ; > $month = substr($fromMysql, 4, 2) ; > $day = substr($fromMysql, 6, 2) ; > > $thedate = $year."/".$month."/".$day ; > > HTH > > Sam Masiello > System Analyst > Chek.Com > (716) 853-1362 x289 > smasiello@chekinc.com > > -----Original Message----- > From: kenji chan [mailto:kenjikenji@bigpond.com] > Sent: Wednesday, November 15, 2000 3:01 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Data / Time problem > > Data / Time problem: > How to format a date from Mysql column ( timestamp(8) ) to "Year / Month / > Day" ? > I got a problem , For examlp : > > ********* > $fromMysql = "19811229"; > > echo date("Y / m / d", $fromMysql); > ********* > > I would like to see 1981 / 12 /29 ,but I got the result : > 1970 / 08 / 18 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >

« previous php.db (#4461) next »