Date Format from JavaScript into MySQL Date type

Question

I can't figure out how to convert the date from this format: Tue Feb 06 2018 19:41:58 GMT-0500 (Eastern Standard Time) into a format that would be accepted by MySQL DATE type.

I can convert the date with this approach in JavaScript:

var day = Date.getDate();
var month = Date.getMonth() +1;
var year = Date.getFullYear();
var DateInMySqlFormat = year + '-' + '0' + month + '-' + day;

This will work fine. But is there any way that I can convert the date Tue Feb 06 2018 19:41:58 GMT-0500 (Eastern Standard Time) on the server side with PHP? Any help would be greatly appreciated!

score 0 · Answer 1 · answered Feb 11 '18 at 01:07

0

$date = 'Tue Feb 06 2018 19:41:58 GMT-0500';
$timestamp = strtotime($date);
echo date('Y-m-d H:i:s', $timestamp);

answered Feb 11 '18 at 01:07

bumperbox

10,166
6
43
66

2

Please add some explanation to your code. – K.Sopheak Feb 11 '18 at 03:39
What part are you having trouble understanding? – bumperbox Feb 11 '18 at 03:45
1

I understand your code but I just suggest you to improve your answer by just adding some description not just provide only code. Look here: https://stackoverflow.com/help/how-to-answer – K.Sopheak Feb 11 '18 at 03:50

score 0 · Answer 2 · answered Feb 11 '18 at 01:08

You can send the DateInMySqlFormat to the backend and then you can create a DateTime object from createFromFormat method, which then can be manipulated with format method to change the format to some other. Available formats from official docs here.

$date = DateTime::createFromFormat('Y-m-d', '2018-02-11');
echo $date->format('Y/m/d'); //2018/02/11
echo $date->format('Y-M-d'); //2018-Jan-11

Date Format from JavaScript into MySQL Date type

2 Answers2