Comparing dates in js / jquery

Question

I am very beginner in JS / JQUERY. I have this code:

var dateFromDB = '2019-12-27 19:12'; // this is data from MySQL

I need compare 2 date/datetime: dateFromDB with actualDataTime - 3 minutes

if (dateFromDB <= (actualDataTime - 3 minutes)]) {
     console.log('user is online');
} else{
console.log('user is offline offline')
}

How can I make it?

If you have the ability to store your timestamps with a timezone in your database you'll save yourself a lot of headache - especially if you have users that are in different timezones. — Wex
– Wex, Commented Dec 28, 2019 at 17:04

vvolkov · Accepted Answer · 2019-12-28 17:02:21Z

1

You can just substract two Date objects and check the difference in milliseconds:

if (new Date(actualDataTime) - new Date(dateFromDB) <= 3 * 60 * 1000) {
   console.log('user is online');
} else{
   console.log('user is offline offline')
}

answered Dec 28, 2019 at 17:02

vvolkov

1,21210 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

traffka Over a year ago

I try yours code: var online = null; var actualDataTime = new Date(); if (new Date(actualDataTime) - new Date(chat[4]) <= 3 * 60 * 1000) { online = 'online'; } else{ online = ''; } but it's not working

vvolkov Over a year ago

@traffka what date format do you use in chat[4] variable? That one you mentioned is working: if (new Date('2019-12-27 19:12') - new Date('2019-12-27 19:05') <= 3 * 60 * 1000) { console.log('user is online'); } else{ console.log('user is offline offline')}

Atenean1 · Accepted Answer · 2019-12-28 17:23:14Z

0

You can use momentjs.

After installation:

var dateFromDB = moment('2019-12-27 19:12').format('YYYY-MM-DD hh:mm')
if (dateFromDB >= (moment().subtract(3, 'minutes')).format('YYYY-MM-DD hh:mm')) {
     alert('user is online');
} else{
alert('user is offline')
}

answered Dec 28, 2019 at 17:23

Atenean1

10212 bronze badges

Collectives™ on Stack Overflow

Comparing dates in js / jquery

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related