SQL Timestamp format in PHP

Question

I little bit stuck in SQL datetime format, I'm using datetime format because of sorting reasons.

The issue come that MySQL expect date in yyyy-mm-dd hh:mm:ss format and I need in exactly the opposite dd-mm-yyyy. There is some way pass and get in different format using PHP? .

@SalimIbrogimov isn't necessary. The guy bellow you answer the question. — ArtiMann, Mar 01 '18 at 08:29

score 1 · Accepted Answer · answered Mar 01 '18 at 06:55

Try this should help:

$datedb = "2018-03-01 11:54:33";
$date = date('d-m-Y', strtotime($datedb));
echo $date; // will print 01-03-2018

And read about date() function of php: http://php.net/manual/en/function.date.php; https://www.w3schools.com/php/func_date_date.asp

score 0 · Answer 2 · answered Mar 01 '18 at 06:23

0

Use Strtotime.it Parse about any English textual datetime description into a Unix timestamp

$mydate = "27-12-2017";
$dbdate = date('Y-m-d', strtotime($mydate));
//OP 2017-12-27

answered Mar 01 '18 at 06:23

TarangP

2,711
5
20
41

SQL Timestamp format in PHP

2 Answers2