Viewing post 1 (of 1 total)
I'm getting a similar conversion error converting birthdates. A SELECT that was working fine in 2000 returns an error in 2005.
SELECT Birthday,
CONVERT(datetime,
CASE
WHEN CONVERT(CHAR(5),Birthday,1)='02/29' THEN '02/28/'
...
May 2, 2006 at 12:57 pm
#635434