I have migrated a 2005 db to 2012
There is a stored procedure that run to insert todays date into a table
IF NOT EXISTS(SELECT * FROM tblTime WHERE [Day] = DATEPART(day,GETDATE()) AND [Month] = DATEPART(month,GETDATE()) AND [Year]= DATEPART(year,GETDATE()) ) BEGIN INSERT INTO tblTime (Period,[Day],[Month],[Year],MonthPrefix) VALUES (CONVERT(VARCHAR(10), GETDATE(), 105), DATEPART(day,GETDATE()), DATEPART(month,GETDATE()), DATEPART(year,GETDATE()), CASE DATEPART(month,GETDATE()) WHEN 1 THEN 'JAN' WHEN 2 THEN 'FEB' WHEN 3 THEN 'MAR' WHEN 4 THEN 'APR' WHEN 5 THEN 'MAY' WHEN 6 THEN 'JUN' WHEN 7 THEN 'JUL' WHEN 8 THEN 'AUG' WHEN 9 THEN 'SEP' WHEN 10 THEN 'OCT' WHEN 11 THEN 'NOV' WHEN 12 THEN 'DEC' END ) END
When this is run on the new 2012 SQL box the date gets put in as
But the same SP on the old 2005 would read
I have checked that the 2 servers have the same language settings etc.
But is there something I have missed.
Many thanks for reading.