[dba-Tech] Quick SQL Question

[Martin Reid]

We have a view created for us in SQL Server. Field of interest is DateOfBirth

In the query interface it si showing as 21/1/2001

However, for some records when we are getting the data from the view there is a time stamp 21/1/2011 00:00:00

The person creating the view is using

CONVERT(varchar(10),ta.BIRTHDATE,103)

The majority of records are fine its just the odd one or two that return the time portion with the date of borth?

Martin