Add time to curtime

Databases
1

Hi,
I’ve to add 12 hour.
Is it the right way ?


SELECT `schedule`.* FROM `schedule` WHERE (language = 'it') AND (end > CURTIME()) AND (start < ADDTIME(CURTIME(), '12:00:00')) AND (`date` = CURDATE( )) ORDER BY `video_id` ASC

Thanks in advance

2

use CURRENT_TIMESTAMP + INTERVAL ‘12’ HOUR