Hi,
I have the following Select Statement;
SELECT dbo.Consultation.ConsultationID, dbo.LkupConsultationType.ConsultationTypeID, CONVERT(VARCHAR(10), dbo.Consultation.ConsultationDate, 103) AS ConsultationDate
FROM dbo.Consultation WITH (tablock) LEFT OUTER JOIN
dbo.LkupConsultationType ON ISNULL(dbo.Consultation.ConsultationType, 0) = ISNULL(dbo.LkupConsultationType.ConsultationType, 0)
The problem is that it converts 'ConsultationDate' to varchar(10).
On the table dbo.Consultation.ConsultationDate is datatype "Datetime".
The Results is fine and ConsultationDate is in the expected format 26/02/2006, which is OK. But the statement makes the column varchar(10) and I want it to retain the Date datatype.
Please help me out.
Thanks