moment convert this DD.MM.YYYY to YYYY-MM-DD format

Question

I have an API that accepts a date in this format 20.02.2020, but I have to save it in MySql, so I need this format 2020/02/20, I have tried using replace function and regex. But didn't get the desired output.

let dt='20.02.2020';
dt.replace('/./g','')

new Date('20.02.2020'.split('.').reverse()).toISOString().split('T')[0].replace(/\-/g, '/') — shrys, Mar 04 '20 at 07:40

score 1 · Answer 1 · answered Mar 04 '20 at 08:07

1

Import moment through npm and pass desired dataFormat as argument.

  moment(date, moment.ISO_8601, true).local().format(dateFormat)

answered Mar 04 '20 at 08:07

Sugandha Sharma

21
2

score 0 · Answer 2 · answered Mar 04 '20 at 08:32

0

Here's one of many regex solutions:

dt.replace(/([0-9]*?)\.([0-9]*?)\.([0-9]*)/gmi, '$3\/$2\/$1');

I find the most elegant solution if you have to reuse dt's value is the split reverse and join which was demonstrated by Tewathia

answered Mar 04 '20 at 08:32

Beavatron Prime

309
2
4

moment convert this DD.MM.YYYY to YYYY-MM-DD format

2 Answers2