Format JSON DateTime

Question

I currently have all my dates being returned with the letter T in my JSON Strings. EX: 2019-02-03T06:48:07. Is there a way to change the JSON String to return as 02-03-2019 06:48:07?

I am also using javascript to load the dates currently into a data table.

Your question is a little vague. I assume this JSON data comes from some sort of API. Are you maintaining this API? If so, change the data to return the date/ time in whichever format you choose. — nopassport1
– nopassport1, Commented Jan 22, 2020 at 15:35
You may want to consider NOT changing it at the API. It depends on how reusable you want the API to be, but generally the ISO 8601 format is the preferred format for date/time information in an API. This allows the client code to determine the formatting. Should you want to change the format down the road, it is generally easier to alter and deploy the client code than changing the API. — musicfuel
– musicfuel, Commented Jan 22, 2020 at 15:55

0bero · Accepted Answer · 2020-01-22 15:41:29Z

2

You can convert your string into a Date object and then format it like this:

let jsonString = "2019-02-03T06:48:07";

// You should set your own timezone and options.
console.log(new Date(jsonString).toLocaleString('en-US', {hour12: false}))

For more information, visit: https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toLocaleString

answered Jan 22, 2020 at 15:41

0bero

1,0641 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Steve Wolfe Over a year ago

that worked, is there a way to remove the comma after the date? 1/10/2020, 09:21:33

0bero Over a year ago

You could use replace, but it could behave unexpectedly. See this question for more info: stackoverflow.com/questions/49982572/…

musicfuel · Accepted Answer · 2020-01-22 15:41:28Z

The T is there because this is a standard ISO 8601 format. It makes it very easy to parse on the client side:

var myDate = new Date('2019-02-03T06:48:07')

With myDate you can then do whatever formatting you wish. Assuming you have another function to handle leading zeros, that could be something like:

var myFormattedDate = padLeft(myDate.getMonth() + 1, '0') + '-' + 
                      padLeft(myDate.getDay(), '0') + '-'
                      myDate.getFullYear() + ' ' +
                      // etc

Note that your timestamp lacks any timezone information. With this code it will be interpreted on the client side in whatever the local timezone of the user is. If it is UTC time, then you can correct for this by adding either 'Z' or '+00:00' onto the timestamp before parsing in the Date constructor.

If you are able to add a library to assist, this all becomes much easier with moment.js:

myFormattedDate = moment('2019-02-03T06:48:07').format('MM/DD/YYYY HH:mm:ss');

Collectives™ on Stack Overflow

Format JSON DateTime

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related