hi all, i find an alternate solution.
my current query :
<pre>CONVERT(VARCHAR,BIS_RequestMaster.RequestDate,101) + ' ' + CONVERT(VARCHAR,BIS_RequestMaster.RequestTime,100) AS RequestDate</pre>
changed to :
<pre>CONVERT(DATETIME,(CONVERT(VARCHAR,BIS_RequestMaster.RequestDate,101) + ' ' + CONVERT(VARCHAR,BIS_RequestMaster.RequestTime,100)),101) AS RequestDate</pre>
i dont know whats this :( but want to change in all place of my code. is this the only solution :((