I have a field that has a datatype of Date. When I select this field in a stored procedure, sql is passing back a time with the date. When I run the select statement in SMS I just get the date. I do not want the time, and I am not even sure where it is coming from.
Here is the select statment:
Select s.SampleTakenDate, s.SampleTakenTime, s.SampleTakenBy, s.SampleReceivedDateTime, s.SampleReceivedBy, s.SampleStatus, s.SampleBottleLot, r.ReferenceNumber, ss.SampleSourceName, s.TestType
from Sample s
left join Reference r on r.ReferenceID = s.SampleReferenceID
left join SampleSource ss on ss.SampleSourceID = s.SampleSourceID
where s.SampleBottleID = @bottleID
The field I am looking at is the very first one (SampleTakeDate).