update ScheduleTable set
 ScheduleStop='15-feb-2005 19:36:00'
,Status='active' where scheduleid=100


Here column name "ScheduleStop" is Varchar(50)
But I am getting the error
"Syntax error converting datetime from character string"

Actually i want to store the same data in varchar field.
How can i do ,i have tried CAST,Convert too.
Looking for help :)
Thanks in Advance

Cheers :)

vinod

__________________
Cheers :)

vinod

u would not use any type casting function (CAST or convert), as this is automatically converted to varchar.

But for testing u can run this T-Sql in query analyzer, If this is running perfectly ok, then u have to check ur code. Let us know if problem presists.

Declare @ScheduleStop as varchar(50)

set @ScheduleStop='15-feb-2005 19:36:00'

select @ScheduleStop


Amit Jain
Sr. Software Engineer

a few days ago i had to restart my computer and the first thing it tells me is that
ST String dll can not be found and then it begins to search for it and then it tells me it needs to be downloaded from a disc that came with my computer lol lol really please i am a 59 year old grand mother and well i guess you might call me computer illiterate. can someone please send me a link to download this dll?