How to convert datetime YYY-MM-DD HH:mm:ss to MM/DD/YYYY HH:mm:ss AM/PM

Question

Can any one help me to covert the datetime to this

04/01/2017 12:30:05 PM

format using jquery.

http://stackoverflow.com/a/23080023/4248328 OR https://www.codeproject.com/Questions/1009120/Convert-one-Date-format-into-another-date-format-i — Anant Kumar Singh, Apr 11 '17 at 05:40

score 0 · Answer 1 · answered Apr 11 '17 at 05:39

I think this can help you

Theres a getDateFromFormat() function that you can tweak a little to solve your problem

OR

var sDate = new Date(Date.parse("XXX","ZZZ"));

Where XXX is your Date string. And ZZZ is your format for XXX.

i.e.

If I want to convert string "2017-04-01 12:30:05" which is in "MM/dd/yyyy hh:mm:ssa" format then

var sDate = new Date(Date.parse("2017-04-01 12:30:05","MM/dd/yyyy hh:mm:ssa"));

Why bother with jQuery? Take a look at datejs.

To execute this i need to add date.js plugin ?? – user123 Apr 11 '17 at 06:02 — user123, Apr 11 '17 at 06:02

4b0 · Answer 2 · 2017-04-11T06:02:25.640

Using getDate , getMonth , getFullYear and for time use getHours , getMinutes and getSeconds you can do this easily and get format what ever you want.

var formattedDate =new Date("04/01/2017 12:30:05 PM");
var d = formattedDate.getDate();
var m =  formattedDate.getMonth();
m += 1;  // months are 0-11
var y = formattedDate.getFullYear();
var t = formattedDate.getHours() + ":" + formattedDate.getMinutes() + ":" + formattedDate.getSeconds();
console.log(d + "_" + m + "_" + y);
console.log(m + "_" + d + "_" + y);
console.log ('Time: ' + t );

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

score 0 · Accepted Answer · edited May 23 '17 at 12:09

0

If you want to use only jQuery, Try this:

/* Convert your date string to date object */

var strDate = "2017-04-01 12:30:05"
var regex = /(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/;
var arrDate = regex.exec(strDate); 
var objDate = new Date(
    (+arrDate[1]),
    (+arrDate[2])-1, // Month starts at 0!
    (+arrDate[3]),
    (+arrDate[4]),
    (+arrDate[5]),
    (+arrDate[6])
);

/* Convert the date object to string with format of your choice */

var newDate = objDate.getMonth() + 1 + '/' + objDate.getDate() + '/' + objDate.getFullYear();

/* Get the time in your format */

var newTime = objDate.toLocaleString('en-US', { hour: 'numeric',minute:'numeric', second: 'numeric', hour12: true });

/* Concatenate new date and new time */

alert(newDate + " " + newTime);

Here is the reference to convert your date string to date object.

edited May 23 '17 at 12:09

Community

1
1

answered Apr 11 '17 at 06:33

Senjuti Mahapatra

2,522
4
25
38

thanq so much @Senjuti Mahapatra. – user123 Apr 11 '17 at 08:26
when give this date(2017-04-11 02:15:06),it is giving AM. – user123 Apr 11 '17 at 08:30
@user123 Yes because the time here is given in 24 HR format. So, 02:00 is 2 AM in the night, while 14:00 is 2 PM in the noon. – Senjuti Mahapatra Apr 11 '17 at 09:37
How can we change that to 12 HR format.Can you tell. – user123 Apr 11 '17 at 10:21
Thanq so much @Senjuti Mahapatra – user123 Apr 12 '17 at 11:45
How can i change to 24 HRS Format,have to remove hour12: true ??? @Senjuti Mahapatra – user123 Apr 25 '17 at 08:03
@user123 Set `hour12: false` – Senjuti Mahapatra Apr 25 '17 at 10:10
Ya i did that hour12: false but AM/PM is not coming..how to set AM/PM – user123 Apr 25 '17 at 11:08
@user123 There is no AM/PM if you choose 24 hr format (`hour12: false`). AM/PM is only for 12 hr format (`hour12: true`). – Senjuti Mahapatra Apr 25 '17 at 12:03
I need to put AM/PM in my project any alternate way. – user123 Apr 25 '17 at 12:06
Check if hour is greater than 12 and <=24, append PM else AM. – Senjuti Mahapatra Apr 25 '17 at 12:09
Thanq so much @ Senjuti Mahapatra – user123 Apr 25 '17 at 12:11

How to convert datetime YYY-MM-DD HH:mm:ss to MM/DD/YYYY HH:mm:ss AM/PM

3 Answers3