How to parse JSON format date string into date format
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);
Ahmer Ali Ahsan
A results-driven, customer-focused, articulate and analytical Software Developer who can think “out of the box”. I am passionate about what I do and always give 100%. When I undertake a project or task, I don't just complete it, I go the extra mile and make it better than requested. 4 years of experience as a ASP.Net Developer Intermediate NodeJS - Angular 2,4,5,8 - MEAN Stack Developer Intermediate Firebase Data Structure Designer Also worked on fiverr.
Updated on June 09, 2022Comments
-
Ahmer Ali Ahsan almost 2 years
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.