Datetime conversion

[be1s]

Here's a piece of code that runs well from QA but when placed in a SP it errors out with "Syntax error converting datetime from character string" Any idea why?

create table #test (appt_time varchar(255),
dtAppt_time datetime null)

insert into #test(appt_time)
values ('2:20 AM')

update #test
set dtAppt_time = convert(datetime,appt_time)

 

[amrita418]

Can you post all the relevant code in your sp?

Regards,
AA

 

[dwight1]

I have a similar problem and the reason is you have some fields that do not have any data/blank for the date column. That is one of the reasons for that kind of error message.

I do not know the solution of how to write a code to ignore blank spaces.

Dwight