note 7320 deleted from sprintf by torben
| From: | torben@php.net | Date: | Tue, 12 Sep 2000 07:27:38 +0000 |
| Subject: | note 7320 deleted from sprintf by torben | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-4752@lists.php.net to get a copy of this message | ||
This is my function for converting mysql dates into dates to be passed to the php date
function...<br>
<pre>
cfunction mysqlDate($date) {
ereg("(....)(..)(..)(..)(..)(..)",$date,$reg);
return mktime($reg[4],$reg[5],$reg[6],$reg[2],$reg[3],$reg[1]);
}
echo date("M d Y",mysqlDate($somedb->f('datefield'));
</pre>
<br>
This is a good function to keep in all your db code..