vendredi 5 février 2016

Cordova SQLite DATE query

Helo, I have Receipt table that I am trying to SELECT data from by date conditions.

The format when I select somthing looks like this:

DateIssue DATE format: Thu Feb 04 2016 23:09:15 GMT+0100 (Střední Evropa (běžný čas))

So I have query query:

tx.executeSql('SELECT ri.ProductId, ri.Name as riName FROM ReceiptItem ri INNER JOIN
Receipt r ON r.ID = ri.ReceiptId WHERE   
r.DateIssue >= ? AND r.DateIssue <= ? GROUP BY ri.ProductId', [dateFrom, dateTo], function..

[dateFrom] Mon Feb 01 2016 23:59:59 GMT+0100 (Střední Evropa (běžný čas))

[dateTo] Mon Feb 29 2016 23:59:59 GMT+0100 (Střední Evropa (běžný čas))

No records get selected,

I am using SQLite plugin: http://ift.tt/1O3yCJy

This is how I pase the input date:

//Parse TO DATE
var dTo = $scope.data.dateTo;
dTo.setHours(23, 59, 59);
var toParsed = Date.parse(dTo);
var dateToFull = new Date(toParsed);

Aucun commentaire:

Enregistrer un commentaire