[dba-Tech] Quick SQL Question

[Paul Hartland]

hhmm thats a weird one been using sql for many years and converting dates
in a similar manor and never had a problem, I am assuming that the years in
the date were a typo (2001 and 2011)....where is the
CONVERT(varchar(10),ta.BIRTHDATE,103) is this in the view that is sometimes
returning the time portion as well ?

have you tried comparing the results your getting with ta.BIRTHDATE  i.e.
select  CONVERT(varchar(10),ta.BIRTHDATE,103) as Converted_DOB,
ta.BIRTHDATE as DOB and see what you get  in the DOB when a time portion
shows in the  Converted_DOB ?

Paul

On 26 July 2018 at 15:57, Martin Reid <mwp.reid at qub.ac.uk> wrote:

> 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
>
>
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com