[dba-Tech] Quick SQL Question

[Gustav Brock]

Hi Paul

A date value carries no format, so just apply the format the users need where it is displayed.

/gustav

________________________________________
Fra: dba-Tech <dba-tech-bounces at databaseadvisors.com> på vegne af Martin Reid <mwp.reid at qub.ac.uk>
Sendt: 26. juli 2018 16:57:26
Til: Discussion of Hardware and Software issues (dba-tech at databaseadvisors.com)
Emne: [dba-Tech] Quick SQL Question

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