This content has been marked as final. Show 2 replies
If you know you only have hours and minutes in the field you can use something like
select to_char((to_date('07:50', 'hh:mi') + 1/24), 'hh:mi') from dual
1. converts the value to a datetime
2. adds one hour
3. converts the datetime back to a string
Just use your column name instead of '07:50'
main obstacle being that clockin_time is a varchar
Seems like you already know this is a bad thing to do.