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);

           }

       })

   }

})