[dba-Tech] Quick SQL Question

Stuart McLachlan stuart at lexacorp.com.pg
Thu Jul 26 16:01:30 CDT 2018


The query is returning a 10 character string, not a data, (DD/MM/YYYY) so the conversion to 
a datetime (timestamp0  must be happening in yoursubsequent  interpretation of the string. 

How exactly are you using the DOB?

On 26 Jul 2018 at 14:57, Martin Reid 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
> 




More information about the dba-Tech mailing list