If I have the following entry inmy db:
Type: datetime Format: 0000-00-00 00:00:00
How do I display only 0000-00-00 (date without time)?
http://www.php.net/strtotime http://www.php.net/strftime
//code to get date from db, result read into $row print strftime("%Y-%m-%d",strtotime($row['datefield']));
OR
http://www.php.net/substr
print substr($row['datefield'],0,10);
perfect! I should look better in the manual before posting next time.
