How to parse JSON format date string into date format

Question

What I am doing is, fetching data from database using ajax and show it on html text boxes for update purposes. Below is my Web Method code from where I get data successfully.

[WebMethod]
public static List<Employee> getEmployee()
{
     var slist = new List<Employee>();
     var db = new BLUEPUMPKINEntities();
     slist = db.Employees.ToList();
     return slist;
}

Now when I get data from database I got date in this format /Date(725828400000)/. I search google about parse and converting json date string format into html / javascript date also use 3rd party plugins like moment.js and jquery.ui but not solve my problem. Also here I am sharing my code from which I get data from ajax in json format and show it on jquery datatable.

$.ajax({
    url: "Employees.aspx/getEmployee",
    data: null,
    contentType: "Application/json; charset=utf-8",
    responseType: "json",
    method: "POST",
    success: function (response) {
        //alert(response.d);

        var jsonObject = response.d;
        var result = jsonObject.map(function (item) {
            //var date = new Date(item.EMP_DOB);
            //var obj = Date.parse(date);
            var result = [];
            result.push('');
            result.push(item.EMP_FNAME);
            result.push(item.EMP_MNAME);
            result.push(item.EMP_LNAME);
            result.push(item.EMP_EMAIL);
            result.push(item.EMP_DOB); //this is my date column in my database from where date is in yyyy/mm/dd format
            result.push(item.EMP_USERNAME);
            result.push(item.EMP_PASSWORD);
            result.push(item.ID);
            return result;
        });
        myTable.rows.add(result); // add to DataTable instance
        myTable.draw();
    },
    error: function (xhr) {
        alert(xhr.status);
    },
    Failure: function (response) {
        alert(response);
    }
});

I want date in mm/dd/yyyy format. Please help me to solve my prob.

start by sending ISO date string from server

charlietfl
– charlietfl

2016-02-07 12:16:55 +00:00
Commented Feb 7, 2016 at 12:16 — charlietfl
– charlietfl, Commented Feb 7, 2016 at 12:16

Zohaib Ijaz · Accepted Answer · 2016-05-23 15:28:56Z

6

If there is no issue in adding a dependency, then you can add moment.js and it will help you to format data in any format I am supposing that date from server is in this format '/Date(725828400000)/'

var d = item.EMP_DOB;
result.push(moment(Number(d.match(/\d+/)[0])).format('MM/DD/YYYY'));

If you are unable to add moment js then you can do soemthing like

var date = new Date(Number(d.match(/\d+/)[0]));
var day = date.getDate();
day = day = (day < 10) ? ("0" + day) : day;
var month = date.getMonth() + 1);
month = (month < 10) ? ("0" + month) : month;
var dateStr = day + "-" + month + "-" + date.getFullYear();
result.push(dateStr);

edited May 23, 2016 at 15:28

answered Feb 7, 2016 at 12:00

Zohaib Ijaz

23k7 gold badges43 silver badges63 bronze badges

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

10 Comments

Zohaib Ijaz Over a year ago

@charlietfl I edited my answer, I thought he is getting a valid date string but format is different

Ahmer Ali Ahsan Over a year ago

Thanks for your right answer. Its works me. But Here Is one problem also which is

<asp:Content ID="Content1" ContentPlaceHolderID="Employees_head" runat="server">     <script src="../Scripts/moment.js"></script>     <script src="../js/ajaxcall.js"></script> </asp:Content>

Moment js not access into my ajaxcall external file. so I put ajaxcall --> getEmployee() method outside from the external file so easily I can access it from it. But I want to access my moment() into my ajaxcall method cause in that method I put all ajax method.

Ahmer Ali Ahsan Over a year ago

your previous code shows me correct format. Why you edited it? Actually the main problem is moment() method is not accessible into my ajaxcall.js file. I also put moment.js file reference before but its not access into ajaxcall. If you tell me how can I reference moment.js into ajaxcall.js external file. So I am very thankful to you again.

Zohaib Ijaz Over a year ago

actually @charlietfl down voted that answer , if you are unable to insert moment js then you can create a function to format your date

Ahmer Ali Ahsan Over a year ago

What is d? aur if i put jsonObject.EMP_DOB.match there is no intellisense matches with match

|

Community · Accepted Answer · 2017-05-23 12:17:59Z

0

You already have a data object, which has its methods to extract everything you need.

You can make a function like in this example:

Get string in yyyymmdd format from js date object

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Feb 7, 2016 at 12:30

xabitrigo

1,4411 gold badge13 silver badges25 bronze badges

Comments

Mir Gulam Sarwar · Accepted Answer · 2016-02-07 15:19:04Z

0

Easiest way to do is below (no third party js required)

var data =from row in db.Employees.ToList()
 select new {
    EMP_DOB=row.EMP_DOB.ToString(), row.EMP_FNAME,row.EMP_MNAME,row.EMP_LNAME
     row.EMP_EMAIL,row.EMP_DOB,row.EMP_USERNAME,row.EMP_PASSWORD,row.ID
 };

If you want to format the date you can use

var data =from row in db.Employees.ToList()
     select new {
         EMP_DOB=Convert.ToString(row.EMP_DOB).ToShortDateString(), other properties goes here as shown previously
     };

You wil be able to format it whatever you want using C#

edited Feb 7, 2016 at 15:19

answered Feb 7, 2016 at 12:01

Mir Gulam Sarwar

2,6482 gold badges27 silver badges39 bronze badges

3 Comments

Ahmer Ali Ahsan Over a year ago

Thanks for your comment but your answer not working for me.

Ahmer Ali Ahsan Over a year ago

This error highlighting on row.EMP_DOB.ToString(), Invalid anonymous type member declartor. Anonymous type members must be declared with a member assignment, simple name or member access.

Mir Gulam Sarwar Over a year ago

I just edited my answer, I was outside , so couldn't respond. You may check if you want. You din't need to do anything in client side

Morteza Tourani · Accepted Answer · 2016-06-23 01:14:40Z

0

this method will convert all your WCF type dates to javascript Date object:

var dateRegex = /^\/Date\((d|-|.*)\)[\/|\\]$/;

function convertWCFStringDate(strDate) {
    var matched = dateRegex.exec(strDate);
    if (matched) {
        var parts = matched[1].split(/[-+,.]/);
        return new Date(parts[0] ? +parts[0] : 0 - +parts[1]);
    }
}

answered Jun 23, 2016 at 1:14

Morteza Tourani

3,5665 gold badges44 silver badges48 bronze badges

Comments

zakaiter · Accepted Answer · 2016-02-08 04:51:53Z

-1

var dbDate = "2014/03/12";    
var date    = new Date(dbDate);

// in place of hardcoded date place your string

For your case you are getting a long value as a string from Db. Add one more line

 var newDate = parseInt("725828400000"); // use here your item.EMP_DOB;

Now pass this value to your object. Like

var date = new Date(newDate);


var mm = (date.getMonth()+1)>9?(date.getMonth()+1):"0"+(date.getMonth()+1);
var dd = date.getDate()>9?date.getDate():"0"+date.getDate();
var yyyy = date.getFullYear();
var newDate = mm+"/"+"/"+dd+"/"+yyyy;
alert(dbDate+" converted to "+newDate)

edited Feb 8, 2016 at 4:51

answered Feb 7, 2016 at 12:12

zakaiter

4393 silver badges11 bronze badges

3 Comments

Ahmer Ali Ahsan Over a year ago

I am getting date into /Date(725828400000)/ this format not in this "2014/03/12"

Ahmer Ali Ahsan Over a year ago

var date = new Date(item.EMP_DOB) // its shows me NaN error

zakaiter Over a year ago

try this: var newDate = parseInt("725828400000"); // use here your item.EMP_DOB; Now pass this value to your object. Like var date = new Date(newDate); You are passing long value as a string hence you are not able to parse.

Collectives™ on Stack Overflow

How to parse JSON format date string into date format

5 Answers 5

10 Comments

Comments

3 Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

10 Comments

Comments

3 Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related