How to convert datetime to yyymmdd format

Question

I am getting date in following format

20.04.2013 09:33:34

I want to make it as 2013.04.20 09:33:34

Any ideas how to do this using javascript or jquery?

@MikeChristensen can you show me how? I have already downloaded date.js — James, Jul 24 '13 at 19:32
Did you read the docs? What did you try? Date.js already seems to parse that format natively, so it should be pretty easy. — Mike Christensen, Jul 24 '13 at 19:35
Well someone is voting down every single answer, but try something like: `var date = Date.parse('20.04.2013 09:33:34'); var formatted = date.toString('yyyy.MM.dd HH:mm:ss');` — Mike Christensen, Jul 24 '13 at 19:40
@MikeChristensen when i do Date.parse and pass date then i get Nan — James, Jul 24 '13 at 19:56

David Sherret · Answer 1 · 2013-07-24T19:42:09.650

1

Split by a space or period. Then take the appropriate sections and combine them together like so:

var s = "20.04.2013 09:33:34".split(/[ .]/)
console.log(s[2] + '.' + s[1] + '.' + s[0] + ' ' + s[3]);

No need for any external libraries or to load it into a Date object.

edited Jul 24 '13 at 19:42

answered Jul 24 '13 at 19:32

David Sherret

92,051
24
178
169

score 1 · Answer 2 · answered Jul 24 '13 at 19:33

1

You can achieve this by using Moment.js:

var date = moment("20.04.2013 09:33:34", "DD.MM.YYYY HH:mm:ss");
date.format("YYYY.MM.DD HH:mm:ss")
// "2013.04.20 09:33:34"

answered Jul 24 '13 at 19:33

gustavohenke

39,785
13
117
123

I think someone came along and downvoted all the answers in this question (including the ones that were deleted) – David Sherret Jul 24 '13 at 19:55
Yea, I was gonna post a date.js version but decided against it. – Mike Christensen Jul 24 '13 at 20:11

score -1 · Answer 3 · edited Jul 24 '13 at 19:43

-1

Need to do this

var date = "20.04.2013 09:33:34".split(/[ .]/);
var newData = date[2] + "." + date[1] + "." + date[0] + " " + date[3];
console.log(newData); // Outputs: "2013.04.20 09:33:34"

edited Jul 24 '13 at 19:43

David Sherret

92,051
24
178
169

answered Jul 24 '13 at 19:34

Ed Heal

57,599
16
82
120

Why this answer has a downvote? – RahulD Jul 24 '13 at 19:57

How to convert datetime to yyymmdd format

3 Answers3