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 stackoverflow.com/questions/2215354/… it might help you with what you are looking for — Ricardo Alves
– Ricardo Alves, Commented Aug 16, 2013 at 15:05
DATE-TIME returns readable string, are you looking to change the order? — Mr. Alien
– Mr. Alien, Commented Aug 16, 2013 at 15:06

Bora · Accepted Answer · 2013-08-16 15:05:49Z

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, 2013 at 15:05

Bora

10.7k5 gold badges50 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2443795 · Accepted Answer · 2013-08-16 15:08:58Z

-1

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

answered Aug 16, 2013 at 15:08

user2443795

1387 bronze badges

Collectives™ on Stack Overflow

Converting datetime from SQL to string in PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related