SQL Date Question

[Wallie12]

I have the following in SQL Server 2008
Parm Input is Start as datetime

If I hard code a Date it works:
UPDATE [WORKING_SVR_CLOSED]
SET [TTRHours] = 'Yes'
FROM [GM].[dbo].[DATA_CLEANING] AS dc
LEFT OUTER JOIN [GM].[dbo].[WORKING_SVR_CLOSED] AS o ON DC.Number = o.DimensionDataRef
WHERE DC.[Date ] = CONVERT (CHAR(255),'04/14/10',107)

This Does not work:
UPDATE [WORKING_SVR_CLOSED]
SET [TTRHours] = 'Yes'
FROM [GM].[dbo].[DATA_CLEANING] AS dc
LEFT OUTER JOIN [GM].[dbo].[WORKING_SVR_CLOSED] AS o ON DC.Number = o.DimensionDataRef
WHERE DC.[Date ] = CONVERT (CHAR(255),@StartDate,107)

@StartDate comes out 2014/04/14

How can I correct this? Thanks in advance!

 

[markros]

If your date field in fact character?

PluralSight Learning Library

 

[djj55]

I do not know if it makes a difference but have you tried VARCHAR instead of CHAR? Do you really need 255 characters as I believe trailing spaces are ignored?

If you look at @StartDate it will show 2014/04/14 as that is how SQL looks at dates. As markros asks is DC.[Date] a character column?



djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!