Date comparing

[Rat32]

How I can compare the date? I have in MYSQL date for example "12-12-2015 13:34" and i want to check

whether it's been 30 minutes.

[Rat32]

How I can compare the date? I have in MYSQL date for example "12-12-2015 13:34" and i want to check

whether it's been 30 minutes.

[Noki]

I would recommend using Unix timestamps in the future. They are much easier to compare in both Lua and MySQL.

You will have to use MySQL's `STR_TO_DATE` function to convert your date into YYYY-MM-DD HH:MM:SS format, then convert that into a timestamp using `UNIX_TIMESTAMP` (with your previous date conversion as an argument). Then you can compare that with `UNIX_TIMESTAMP()` (note the lack of arguments), which is the current Unix timestamp.

Quite tedious to be honest.

Something like this:

dbQuery(db, "SELECT `column1` FROM `table` WHERE UNIX_TIMESTAMP() - UNIX_TIMESTAMP(STR_TO_DATE(`column2`, '%Y %m %d %h:%i%p')) >= 32")