CODEWITHSUNDEEP
javascriptjquerydatetime
moikey
moikey

Reputation: 353

JQuery datetime to milliseconds

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?

Upvotes: 7

Views: 33108

Answers (6)

Nodoze
Nodoze

Reputation: 680

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

Upvotes: 2

LasithaMD
LasithaMD

Reputation: 125

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)

Upvotes: 3

moikey
moikey

Reputation: 353

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.

Upvotes: 5

Rooster
Rooster

Reputation: 10077

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.

Upvotes: 0

jhenderson2099
jhenderson2099

Reputation: 964

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.

Upvotes: 2

Kenny Meyer
Kenny Meyer

Reputation: 8027

>> 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.

Upvotes: 6

Related Questions