PHP/MYSQL: Separate DATETIME to Date only at PHP Page

Question

From my question,

Below is my code

 echo "<td>" . $row['StartTime'] . "</td>";

'StartTime' is a row in a database table that displays DATETIME format. Want to ask, how to display Date only at my PHP page?

You can use date('Y-m-d',strtotime($row['StartTime'])) https://www.w3schools.com/php/php_date.asp — Amanjot Kaur, Nov 11 '19 at 08:12

Vimal · Accepted Answer · 2019-11-11T08:13:40.383

2

Just need to use format function of php as shows

 echo "<td>" .$row['StartTime']->format('Y-m-d'). "</td>";

Hope it helps.

Go through the documentation also

As per the comments

 echo "<td>" .date('Y-m-d',strtotime($row['StartTime'])."</td>";;

edited Nov 11 '19 at 08:13

answered Nov 11 '19 at 07:32

Vimal

Parse error: syntax error, unexpected '.' – Hawau Nov 11 '19 at 07:35
@Hawau Edited.Try Now. – Vimal Nov 11 '19 at 07:37
Fatal error: Uncaught Error: Call to a member function format() on string – Hawau Nov 11 '19 at 07:41
@Hawau I think your starttime field is not datetime format. – Vimal Nov 11 '19 at 07:42
My StartTime is absolutely in DATETIME – Hawau Nov 11 '19 at 07:43
@Hawau Try the new added section on my answer – Vimal Nov 11 '19 at 08:14
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/202138/discussion-between-vimal-and-hawau). – Vimal Nov 11 '19 at 08:20

1 Answers1