How to change the format of date that getting from database

Question

how to change the format of date that getting from database getting date from database showing some error. please check the image

@ Matt Murdock alert shows the out put date format check my img — kannan D.S, Nov 30 '15 at 11:19
What about some code? Some hints? I mean, what format do u use in your db (timestamp or date?) And on which layer do u want to change the format? — MorKadosh, Nov 30 '15 at 11:19
@kannanD.S - Show us some code that you are currently using so that we can take it as a reference and help you out. — Matt Murdock, Nov 30 '15 at 11:21
Possible duplicate of [Converting .NET DateTime to JSON](http://stackoverflow.com/questions/1016847/converting-net-datetime-to-json) — Mosh Feu, Nov 30 '15 at 11:23

Optimus · Answer 1 · 2015-11-30T11:30:58.380

1

try this

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

to format your date use the following code

 var parsedDate= new Date(date); 
var formattedDate =parsedDate.getDate()+"-"+parsedDate.getMonth()+"-"+parsedDate..getFullYear();

edited Nov 30 '15 at 11:30

answered Nov 30 '15 at 11:25

Optimus

@ Optimus thx i got a lond date format now, how to foramat that date to hour and minut – kannan D.S Nov 30 '15 at 11:37

score 0 · Answer 2 · edited Nov 30 '15 at 11:28

0

You could try this, assuming you can manipulate the 'date' you are getting from the database:

d = yourdate();
new_d = d.toUTCString();

There are also .toLocaleTimeString() (for times i.e., 11:11:12 am) and .toDateTimeString() (for days i.e., 11/11/2011)

edited Nov 30 '15 at 11:28

Kaushik Maheta

answered Nov 30 '15 at 11:26

rrd

2 Answers2