Skip to content
Advertisement

Tag: sql-server-2012

CONVERT issue in sqlserver with Msg 529 error

This statement is giving me a error VALUE column Datatype is TEXT in the RESULTS table. How can i overcome the above problem. please help ! Answer You can’t convert from text to datetime You must apply two convert operations. The first: From text to varchar The second: From varchar to datetime So your query will become: Plus: text datatype

Advertisement