const mysql = require('mysql');
const moment =require('moment')
var conn = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root@123',
database:'abc'
})
conn.connect(err => {
if (err) throw err;
else {
console.log("connected");
let lastTimestamp =moment().format('YYYY-MM-DD:h:mm:ss');
console.log(lastTimestamp);
conn.query('SELECT * FROM users WHERE time > NOW() - INTERVAL 30 MINUTE',[lastTimestamp], (err, result) => {
if (err) throw err;
else {
console.log(result);
}
})
}
})

0 Comments