How to change date format into the comma separated column?

Question

I have comma separated value like 2018-06-20 01:12:53,2018-06-20 01:14:11 But the problem is I need date and time format like day-month-Year H:i when I use DATE_FORMAT(t1.pickup_date_time, "%d-%m-%Y %H:%i") it could not run because the column(pickup_date_time) has comma separated value. Your help is appreciated.

Thank you.

Take some time to think about restructuring your data – M Khalid Junaid Jun 20 '18 at 05:04 — M Khalid Junaid, Jun 20 '18 at 05:04

score 2 · Accepted Answer · answered Jun 20 '18 at 04:29

2

Use SUBSTRING_INDEX first to split the column on the comma. Then use STR_TO_DATE to reformat the date. If you have issue with the actual code, let me know.

answered Jun 20 '18 at 04:29

Bleach

561
4
11

How to change date format into the comma separated column?

1 Answers1