javascript - JQuery datetime to milliseconds - Stack Overflow

admin管理员组

文章数量:1192347

I have a web application where I wish to send information to a database.

I have a datepicker, which lets the user select a date and formats the date as "YYYY-MM-DD". In addition to this, the users must also select a time using a timepicker which formats the time as "HH:MM". This gets concatenated into a DateTime string as "YYYY-MM-DD HH:MM".

I need to convert this into milliseconds for the datetime to be accepted as the correct format on the database (locale format of YYYY-MM-DD HH:MM:SS.mmm).

I have a tried a host of solutions found here and elsewhere to try and convert into milliseconds. Whenever I try to concat then convert I usually get a NaN error or "invalid Date" and I cannot simply add the converted milliseconds.

Is there any way of doing this in jQuery or JavaScript?

I have a web application where I wish to send information to a database.

I have a datepicker, which lets the user select a date and formats the date as "YYYY-MM-DD". In addition to this, the users must also select a time using a timepicker which formats the time as "HH:MM". This gets concatenated into a DateTime string as "YYYY-MM-DD HH:MM".

I need to convert this into milliseconds for the datetime to be accepted as the correct format on the database (locale format of YYYY-MM-DD HH:MM:SS.mmm).

I have a tried a host of solutions found here and elsewhere to try and convert into milliseconds. Whenever I try to concat then convert I usually get a NaN error or "invalid Date" and I cannot simply add the converted milliseconds.

Is there any way of doing this in jQuery or JavaScript?

• javascript
• jquery
• datetime

Share Improve this question Follow edited Mar 24, 2012 at 18:27 Michael Petrotta 60.9k2727 gold badges152152 silver badges181181 bronze badges asked Mar 24, 2012 at 18:19 moikeymoikey 35333 gold badges77 silver badges1616 bronze badges 1

• 6 This is something that should be done on the server side. – Jon Commented Mar 24, 2012 at 18:21

Add a comment  | 

6 Answers 6

Sorted by: Reset to default 6

>> var datetime = new Date();
undefined
>> datetime.getTime();
1332613433314

Date.getTime() returns the number of milliseconds since 1970/01/01:

This should be handled server-side, though.

I managed to figure this one out myself. Thanks to those who answered. Its not an ideal solution, but it works.

var d = $("#date").val();
var dateParts = new Date((Number(d.split("-")[0])), (Number(d.split("-")[1]) - 1), (Number(d.split("-")[2])));
var dateis = dateParts.getTime();

var timeEnd = $("#endtime").val();
var time1 = ((Number(timeEnd.split(':')[0]) * 60 + Number(timeEnd.split(':')[1]) * 60) * 60) * 1000;

var timeStart = $("#starttime").val();
var time2 = ((Number(timeStart.split(':')[0]) * 60 + Number(timeStart.split(':')[1]) * 60) * 60) * 1000;

var dateTimeEnd = dateis + time1;
var dateTimeStart = dateis + time2;

What this basically does, is take a date from a datepicker, and a start and an endtime from a timepicker. The ajax accepts 2 datetimes, one for start, one for end. The above solution basically gets all the values from the input values, and converts it to milliseconds. It's not the best way of doing things but it is a quick fix.

I don't realise your actual question, but I've made a code that set the datepicker to a minimum selected day as today the code is as follows :

$("#datefield").datepicker({
    dateFormat:"yy-mm-dd",
    minDate:new Date(new Date().getTime())
});

The return value of the new Date().getTime() is the milliseconds from 1970/01/01 05:30 am (as my system)

Can you use the JavaScript Date object?

You could use it like so: var d = new Date(yyyy, MM, dd, hh, mm, 0, 0).getTime();

You initialize the Date object and then use the getTime function to return the number of milliseconds since Jan. 1, 1970.

$("#datefield").datepicker("getDate").getTime(); will do the trick

I would do this on the server side and use the strtotime function to convert to a timestamp which will give you a number of seconds which if you really need milliseconds for some kind of script : 1 second = 1000 milliseconds.

If anything you could use jquery to validate that you'll be sending a valid date-time to the server side script before you do so.

本文标签： javascriptJQuery datetime to millisecondsStack Overflow