I'm trying to update records to allow for clocks going forward - main obstacle being that clockin_time is a varchar
create table CLOCKS(
ID Number (8),
clockin_time VARCHAR (8)
INSERT INTO CLOCKS
VALUES (001, '07:50');
I've been playing around with to_char and to_date but cant seem to get it quite right....
SET clockin_time = to_date(clockin_time +1/24, 'hh:mi')
WHERE ID = 001;
I know it's not close but I am relatively new to this so any help would be greatly appreciated!
Edited by: 923697 on Mar 27, 2012 8:08 AM
Edited by: 923697 on Mar 27, 2012 8:18 AM