Open devLupin opened 8 months ago
DATEDIFF(END_DATE, START_DATE)
Example
2024-01-27
2024-01-28
DATEDIFF('2024-01-28', '2024-01-27')
28-27 = 1
+1
DATEDIFF('2024-01-28', '2024-01-27') + 1
DATEDIFF(END_DATE, START_DATE)
Example
2024-01-27
~2024-01-28
은 총 2일이다.DATEDIFF('2024-01-28', '2024-01-27')
28-27 = 1
이 된다.+1
을 해줘야 한다.DATEDIFF('2024-01-28', '2024-01-27') + 1