Msg 241, Level 16, State 1, Line 1 Conversion failed when converting datetime from character string.
hi guys
i'm here first time any advice would be appreciated.
insert into ##temp
values(convert(varchar,'select StartDate from JFTest11.dbo.FScalar',112),
null,null,null);
my question is this: i have one main table ,there is one startdate colom which is datetime type. i make one temp table i want to insert all start date value in temp table using above command. there is 4 lakhs record in main table. there is need some change in my query to get all data in temp table pls.
when i'm running this command i got error message all time
Msg 241, Level 16, State 1, Line 1 Conversion failed when converting datetime from character string.
pls help me i,m helpless situation .it's very imp for my project. pls mail me on this id vikassharma_47@hotmail.com
thanks vikas
It should be
insert into ##temp
select convert(varchar(8),StartDate,112),null,null,null from JFTest11.dbo.FScalar
Or possibly this:
insert into ##temp
SELECT convert(varchar,(select StartDate from JFTest11.dbo.FScalar),112),
null,null,null
This will give an error IF the nested select returns more than one row (which may be what you want :) )
