I have a problem with date comparing logic in MySQL and PHP: date difference functions return different results for the same dates. Example: SQL SELECT DATEDIFF('2024-06-02', '2024-05-03 12:57') 30 PHP $x = date_diff( new DateTime( '2024-06-02' ), new DateTime( '2024-05-03…
I have table with changelog, every row give me specify inormation about actions. Example: Ticket closed on 2022-06-26 14:12:07.000 Ticket reopened on 2022-06-28 08:35:59.000 Ticket closed on 2022-06-28 12:55:11.000 Ticket reopened on 2022-06-30 17:04:34.000 In other table I have information…
I want to get the number of days between the two dates. // DD-MM-YYYY $date[0] = "01-03-2023"; $date[1] = "30-03-2023"; echo date_diff(date_create($date[0]),date_create($date[1]))->d + 1; The program above returns 2, instead of the right number of days.