Can anyone help me figure out why the data is not being inserted into WebSQL when using the current date and time for INSERT and SELECT statements? Here's the code I'm currently using:
SETUP..
myDb.transaction(function(tr) {
tr.executeSql('CREATE TABLE IF NOT EXISTS stInfo (keyNum INTEGER NOT NULL PRIMARY KEY, timestamp varchar(255) );');
});
INSERTING DATA
function insert() {
var timeStamp = getCurrentDate(); // returns in format YYYY-MM-DD HH:MM
myDb.transaction(function(tr) {
tr.executeSql("INSERT INTO stInfo('keyNum','timestamp') values(215424," + timeStamp + ");");
});
}