JQuery format value for date

Question

I am updated the value of an HTML input field with data from a query:

$("##warranty_end_date#id#").val(warranty_end_date);

But the data is store in my database as a SQL Date/Time and has an output like this: May, 08 2019 00:00:00 -0400

I would like the data to be formatted like this: 05/08/2016

How can I accomplish this?

Possible duplicate of Where can I find documentation on formatting a date in JavaScript? — godzillante
– godzillante, Commented Dec 23, 2016 at 14:46

Falco · Accepted Answer · 2016-12-23 15:05:23Z

1

warranty_end_date = "May, 08 2019 00:00:00 -0400";

var d = new Date(warranty_end_date);

var f = ("00" + (d.getDate()).toString()).slice(-2) + "/" + ("00" + (d.getMonth()+1).toString()).slice(-2) + "/" + (1900 + d.getYear()).toString();

$("##warranty_end_date#id#").val(f);

answered Dec 23, 2016 at 15:05

Falco

1,6223 gold badges23 silver badges54 bronze badges

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

2 Comments

Brian Fleishman Over a year ago

I actually realized that this is outputting dd/mm/yyyy . How can I switch it to mm/dd/yyyy?

Falco Over a year ago

just switch the part in the middle with the part in beginning: var f = ("00" + (d.getMonth()+1).toString()).slice(-2) + "/" + ("00" + (d.getDate()).toString()).slice(-2) + "/" + (1900 + d.getYear()).toString();

Wouter den Ouden · Accepted Answer · 2016-12-23 14:49:23Z

1

Maybe you could format the date in the SQL query already. Something like:

SELECT convert(varchar, getdate(), 101)

101 = mm/dd/yyyy – 10/02/2008

answered Dec 23, 2016 at 14:49

Wouter den Ouden

1,5233 gold badges19 silver badges45 bronze badges

2 Comments

Brian Fleishman Over a year ago

Unfortunately I am returning a bunch of columns in my query so I cannot do it that way. Does jquery have a simple mask function?

Pegues Over a year ago

I agree this solution would be good to use, but this is not what the OP asked for. I don't understand why this solution is getting up votes.

Balaji Marimuthu · Accepted Answer · 2016-12-23 14:56:11Z

0

var date = new Date('2010-10-11T00:00:00+05:30');
alert((date.getMonth() + 1) + '/' + date.getDate() + '/' +  date.getFullYear());

answered Dec 23, 2016 at 14:56

Balaji Marimuthu

2,06814 silver badges14 bronze badges

1 Comment

ShahiM Over a year ago

Please consider elaborating a little instead of posting plain code. The objective here is to educate, not spoon-feed.

Pegues · Accepted Answer · 2016-12-23 15:41:47Z

0

You can accomplish this using the following:

var date = new Date('May, 08 2019 00:00:00 -0400');
var output = date.toLocaleFormat('%m/%d/%Y');
alert(output);

Here's a jsfiddle: https://jsfiddle.net/y4zemzqg/

Also, look over using moment.js. http://momentjs.com/ Moment.js makes formatting dates and time incredibly easy. I've used it for quite some time with no issue:

var theDate = moment('May, 08 2019 00:00:00 -0400').format('MM/DD/YYYY');
alert(theDate);

Here is a JS Fiddle using the moment.js solution: https://jsfiddle.net/v923bn5s/

edited Dec 23, 2016 at 15:41

answered Dec 23, 2016 at 14:57

Pegues

1,7933 gold badges23 silver badges40 bronze badges

Collectives™ on Stack Overflow

JQuery format value for date

4 Answers 4

2 Comments

2 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related