Skip to content
Advertisement

Tag: datetime

Comapring DATE_ADD with NOW not working on MySQL

I’ve try to compare an DateTime in MySQL. The table is to check locked users. For sample, an User will be locked for 1 Day at the DateTime 2020-04-09 14:51:32: until is the datetime time_created with added days from locked_time. Here is the Result of entries: The calculation (time_created with added locked_time with the result 2020-04-10 14:51:32) is correctly. But

Time difference between rows

In a mysql database (ver.5.7.15) I’ve got the following table named operation_list containing the following data: id (autoincrement integer, primary key), operation_date_time (datetime), operation (…

Advertisement