How to display the date only from a TIMESTAMP value.
I have a database table with numerous columns, one of which is automatically populated with a TIMESTAMP value when a new record is created. I have a record set that collects data from these columns so I can display them in a HTML table. The TIMESTAMP column is named 'app_date' so I have the following HTML / PHP;
<td><?php echo $row_rsMember['app_date']; ?></td>
This displays the following - 2016-04-13 10:56:30. But all I want is - 2016-04-13.
How can I adjust the code to achieve this?
Thanks in advance.