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