How can I format MySQL date response to be MM-DD-YYYY?

Question

Does anyone know how to format this MySQL response to have JUST the date in the format of MM-DD-YYYY? For example, I want the below response to be formatted in 12-02-2020

date: '2020-12-02T08:00:00.000Z'

I tried doing the lines below but didn't seem to work

let formattedDate = new Date(Date.parse(entry.date.replace(/-/g, '/')));

The duplicate question is almost exactly what you need. Just replace `[year, month, day]` with `[month, day, year]`. — str, Dec 03 '20 at 21:32

score 0 · Answer 1 · answered Dec 03 '20 at 21:11

0

You can use date_format() in your SQL query:

date_format(mydate, '%m-%d-%Y')

answered Dec 03 '20 at 21:11

GMB

216,147
25
84
135

do you know if there is a way to do it without using SQL queries? – SamuelP Dec 03 '20 at 21:21

How can I format MySQL date response to be MM-DD-YYYY?

1 Answers1