SQL server ERROR

Question

AM getting this error while performing this query operation

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

here' s my query

SELECT

MaxDate,

MinDate,

DATEDIFF(D, MaxDate, MinDate)

FROM (

SELECT

(SELECT MAX(TDate) ) AS MaxDate

,(SELECT MIN(TDate) ) AS MinDate

FROM EDATA

)a

Abhishek Jaiswal · Answer

Hey rahul I was using Simply DATE as datatype  that's why that error was occuring. but when i changed it into DATETIME the same query is working for me as well. Between thanks for ur kind suggestion.:)

Abhishek Jaiswal · Answer

Hey Ramesh! Cast and convert were not working I already tried.

Ramesh Maruthi · Answer

1 way : SELECT MaxDate MinDate convert(datetimeDATEDIFF(D MaxDate MinDate)) as diff FROM ( SELECT (SELECT MAX(TDate) ) AS MaxDate (SELECT MIN(TDate) ) AS MinDate FROM EDATA )a 2 way: SELECT MaxDate MinDate DATEDIFF(D MaxDate MinDate) as diff FROM ( SELECT (SELECT cast( MAX(TDate) as datetime) ) AS MaxDate (SELECT Cast(MIN(TDate) as datetime) ) AS MinDate FROM EDATA )a

Rahul · Answer

I tried the same query you mentioned above using a table from my database. Its working for me. Is the column TDate is a of varchar datatype?