JSON Field with date format using Javascript?

Question

As of now I can get the json format of my data using this code

    var bookingReserve = ['{!! $booking !!}'];
    var json = JSON.parse(bookingReserve);
    console.log(json);

and output like this

What I need to do is to generate json format based on the data thrown by bookingReserve

and

set date format Y-m-d to starts_at and ends_at

Unfortunately I can't filter the date format of the fields using laravel as I ask here

Convert DATE_FORMAT to Y-m-d? Using Larave Eloquent Raw Select

So what I'm trying to do is to generate json format and set Y-m-d date format for both fields using javascript

The ideal solution is to have your backend use a date format that JavaScript can understand, eg ISO 8601 — Phil
– Phil, Commented May 14, 2020 at 2:36

Tan Dat · Accepted Answer · 2020-05-14 02:39:04Z

2

const formatDate = dateString => {
    const d = new Date(dateString)
    return `${d.getFullYear()}-${d.getMonth()}-${d.getDate()}`
}

formatted = json.map(obj =>  {
    return {
        starts_at: formatDate(obj.starts_at),
        ends_at: formatDate(obj.ends_at)
    }

})

Or with your case, just need to trim after space.

formatted = json.map(obj =>  {
    return {
        starts_at: obj.starts_at.split(" ")[0],
        ends_at: obj.ends_at.split(" ")[0]
    }

})

answered May 14, 2020 at 2:39

Tan Dat

3,1271 gold badge21 silver badges39 bronze badges

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

1 Comment

Pablo Over a year ago

Been working on this since yesterday spent multiple hours. You saved me today! Thankyou

Collectives™ on Stack Overflow

JSON Field with date format using Javascript?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related