SQL - convert hhmm to datetime
Posted on 2011-04-28
using SQL server 2000
I have a time field that is a char(10) I want to be able to convert it to datetime so can get the semicolon between then hours and mins
what is the SQL code to display the above as
using this: CONVERT(VARCHAR(5), cast(BINTVWS.Time_from as datetime), 108) as interviewTimeStart
Server: Msg 242, Level 16, State 3, Line 13
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.