I have a date variable that stores a date time, e.g. 17/05/2024 13:46:23
I have another varchar variable that stores a time, e.g ’15:21′
I want to take the first variable, truncate it, add 1 day to it, then add the time that is stored in format ‘hh:mm’
So for the example above I want to populate a variable with
trunc(’17/05/2024 13:46:23′) + 1 day + ’15:21′

Giving a result of ’18/05/2024 15:21′