Welsh Corgi (6/24/2013)
Does it matter which method I use as far as performance?
If you're only applying the convert to a variable/static value, like GETDATE(), it doesn't matter at all from a performance point of view. If you have to apply it to a column, then the latter is preferable in most scenarios as it's (mostly) SARGable.