LinuxQuestions.org - [SOLVED] Match datetime by the minute (not an exact match by the second) [mysql]

- Programming (https://www.linuxquestions.org/questions/programming-9/)

- - Match datetime by the minute (not an exact match by the second) [mysql] (https://www.linuxquestions.org/questions/programming-9/match-datetime-by-the-minute-not-an-exact-match-by-the-second-%5Bmysql%5D-839483/)

Match datetime by the minute (not an exact match by the second) [mysql]

I have the following query:

Code:

$sql="SELECT table1.datetime, table1.user_id, table2.ip, FROM table1,table2 WHERE id='$id' AND (table1.id = table2.id AND table1.datetime = table2.datetime)";

In table2 the datetime fields are about 1 to 2 seconds off due to the source of the data, which I cannot change.

Is it possible via a query match table1.datetime & table2.datetime by HH:MM (ie. to the minute instead of to the second)?

Thanks & regards

Quote:

Originally Posted by hattori.hanzo (Post 4134474)

I have the following query:

Code:

$sql="SELECT table1.datetime, table1.user_id, table2.ip, FROM table1,table2 WHERE id='$id' AND (table1.id = table2.id AND table1.datetime = table2.datetime)";

I used:

Code:

DATE_FORMAT( table1.datetime, '%Y-%m-%d %H:%i' ) = DATE_FORMAT( table2.datetime, '%Y-%m-%d %H:%i' ))

which solved it.