Convert Database Date to string from java script

Question

I want to convert row.visitDate to string. Now it will display like - /Date(1581376680000)/

View

<code>
    <div> @Html.DropDownListFor(m => m.AmcvId, new SelectList(""), "--Select Visit--", new { @id = "AmcvId", @class = "form-control" })</div>

</code>
<script>
     $.get("/ComplaintRegistration/GetAmcVisitList", { AmcId: $("#AmcId").val() }, function (data) {
                        $("#AmcvId").empty();
                        $.each(data, function (index, row) {
                            $("#AmcvId").append("<option value='" + row.AmcVisitId + "'>" + row.VisitDate + "</option>")
                        });
                    });
 </script>

Controller:

public ActionResult GetAmcVisitList(int AmcId)
{
    List<AMCVisitDetails> AmcVisitList = new List<AMCVisitDetails>();
    AmcVisitList = db.AmcVisitDetails.Where(t => t.AmcId== AmcId).ToList();

    return Json(AmcVisitList, JsonRequestBehavior.AllowGet);    
}

Eren Peksen · Accepted Answer · 2019-12-10 08:45:51Z

1

I'm parsing .net dates like this.

var date = new Date(parseInt(row.visitDate.substr(6)));

date.toLocaleDateString();

answered Dec 10, 2019 at 8:45

Eren Peksen

1752 silver badges11 bronze badges

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

Comments

Unknown · Accepted Answer · 2019-12-09 06:20:33Z

0

The value displayed which looks like some random garbage number is actually a timestamp value represented in miliseconds. Inorder to convert Timestamp to proper human readable date, simply pass this Timestamp to the Date constructor.

var visitDate = new Date(row.AmcVisitId); //new Date(1581376680000) gives "Mon Feb 10 2020 18:18:00 GMT-0500 (Eastern Standard Time)"

Now you can format it as you prefer for displaying it in the Page.

answered Dec 9, 2019 at 6:20

Unknown

5315 silver badges18 bronze badges

Comments

Ali Maleki · Accepted Answer · 2019-12-09 06:23:13Z

0

use this

new Date(row.VisitDate).toLocaleString()

answered Dec 9, 2019 at 6:23

Ali Maleki

3001 gold badge6 silver badges20 bronze badges

1 Comment

Anirudha Over a year ago

This will not work, result same as it is . $.each(data, function (index, row) { $("#AmcvId").append("<option value='" + row.AmcVisitId + "'>" + new Date(row.VisitDate).toLocaleString() + "</option>") });

Collectives™ on Stack Overflow

Convert Database Date to string from java script

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related