Convert varchar to time

[amitaon]

I have a column StartTime type varchar stors data as 3:59:00 format . I want to write an select query which add 6 in hour and display records. Can any body help

[r035198x]

Have you tried the time function?

select time(columnName) from tableName