Converting datetime from SQL to string in PHP

Question

I have an SQL database table which contains a column which holds data of datetime format. Now, after getting the values of this row, I need to convert the datettime to a readable string, but I'm unable to do this. Here's the code I'm using:

$result = mysqli_query($handle, "SELECT * FROM $dbTable WHERE id=$id");

while($curr = mysqli_fetch_array($result))
{
    // CONVERT $curr['datetimefield'] TO STRING
    // echo $strong-format-of-datetime;
}

The conversion part is what I'm stuck at. If anybody could help with this, I'd be really grateful.

Thank You.

see http://stackoverflow.com/questions/2215354/php-date-format-when-inserting-into-datetime-in-mysql it might help you with what you are looking for — Ricardo Alves, Aug 16 '13 at 15:05
DATE-TIME returns readable string, are you looking to change the order? — Mr. Alien, Aug 16 '13 at 15:06

score 4 · Answer 1 · answered Aug 16 '13 at 15:05

4

You can change format what you want: Y-m-d H:i:s

$date = strtotime($curr['datetimefield']);
echo date('Y-m-d H:i:s', $date);

answered Aug 16 '13 at 15:05

Bora

10,529
5
43
73

score -1 · Answer 2 · answered Aug 16 '13 at 15:08

-1

Also you can convert date while SQL query: STR_TO_DATE(date,'%d.%m.%Y')

answered Aug 16 '13 at 15:08

user2443795

144
7

Converting datetime from SQL to string in PHP

2 Answers2