MySQL – razlika u satima – TIMESTAMPDIFF

Problem: zanima nas popis proizvoda koji su dodani u košaricu unutar 24 sata. Dakle, ne 1 dan jer je između 23:00 i 01:00 drugi dan razlika od jednog dana, ali od samo dva sata.

Rješenje:


SELECT

TIMESTAMPDIFF (HOUR, tbl_kosarica.vrijeme_dodavanja, NOW())  as difference

FROM

tbl_kosarica

WHERE TIMESTAMPDIFF(HOUR, tbl_kosarica.vrijeme_dodavanja, NOW()) < 24
This entry was posted on Friday, September 1st, 2017 at 2:26 pmand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.