Am I correct to assume that @myDate is our starting point?

And that CONVERT only changes the display of the date string according to the added parameter (111 or 105).

Then the calculations should give the same results...

J.

How do you "tell" SQL Server that @myDate is in this format: yyyy-mm-dd?

Declare @myDate varchar(50)

Set @myDate = '2014-04-08'

SELECT CONVERT( char(20), CONVERT( datetime, @myDate))

select (convert(datetime, @myDate,111))+22

select convert(char(20), (convert(datetime, @myDate,111))+22)

select (convert(datetime, @myDate,105))+22

select convert(char(20), (convert(datetime, @myDate,105))+22)

This gives identical results:

Declare @myDate varchar(50)

Set @myDate = '2014/dec/10' --yyyy-mm-dd

SELECT CONVERT( char(20), CONVERT( datetime, @myDate))

select (convert(datetime, @myDate,111))+22

select convert(char(20), (convert(datetime, @myDate,111))+22)

select (convert(datetime, @myDate,105))+22

select convert(char(20), (convert(datetime, @myDate,105))+22)