Home / Questions / 10599
Accepted
Lina Cortés
Asked: 2020-05-21 16:23:43 +0800 CST 2020-05-21 16:23:43 +0800 CST

Compare two hours (TimeStamp) MySql Java

  • 772

I have to compare 2 hours, one that is already registered in the database, and the current time, I have been told that I can use the in MySQL to make it return a true or false and the minutes of difference, then in java I must receive what it returns and depending on what it is to perform an action. Could someone give me an example of this? Thank you very much.

java

2 Answers

  1. Best Answer

    You can also use the TIMESTAMPDIFFMySQL function. To compare the minutes:

    SELECT timestampdiff(MINUTE, nombre_columna, now()) <= 120
  FROM tabla
 WHERE otra_columna = algun_valor

    It will return 1if 120 minutes have not passed yet or 0otherwise, depending on the value of nombre_columna( TIMESTAMP) up to the current time.

    ———————
    NOTE : To use this MySQL function in JPA, a native SQL statement ( createNativeQuery) can be used.

    • 1 
  2. SELECT unix_timestamp( columna ) - unix_timestamp( sysdate() ) AS diferencia FROM tabla;

    It will not return a true or false, but the difference, but with that you process it in the java

    • 0