Date/Time condition

[Thaybow]

Hello,

Does someone can tell me what am I doing wrong ?

DB is installed. The field 'completed' in table is a TEXT (and I have also tried with a DATE).

Trying to do this:

async delete() { const db = await this.getInstance(); await db.transaction((tx) => { const sql = 'DELETE FROM my_table WHERE (completed < DATE(\'now\', \'-1 minute\'))'; tx.executeSql(sql, [], (tx, res) => { console.log('removed'); }, function(tx, error) { console.log('DELETE error: ' + error.message); }); }); }

I can delete everything without the WHERE condition, but I'm stuck when I try to filter with this WHERE (completed < DATE('now', '-1 minute'))

[brodycj]

Thanks. I had trouble following your sample code, reformatting here:

async delete() {
        const db = await this.getInstance();
        await db.transaction((tx) => {
            const sql =
                'DELETE FROM my_table WHERE (completed < DATE(\'now\', \'-1 minute\'))';
            tx.executeSql(sql, [], (tx, res) => {
                console.log('removed');
            }, function(tx, error) {
                console.log('DELETE error: ' + error.message);
            });
        });
    }

I generally recommend formatting JavaScript samples like this:

```js
// some code here
```

(or use ts, jsx, or tsx in case of TypeScript, jsx, or tsx code)

Unfortunately I cannot think of very much without knowing how you populated the completed field in the first place.

Back in 2016 I started to document some pitfalls I discovered related to time and date handling in the following places:

• Test & document date/time handling along with pitfalls cordova-sqlite-storage#546
• https://github.com/xpbrew/cordova-sqlite-storage#general-sqlite-pitfalls

and some important reading here: https://www.sqlite.org/lang_datefunc.html