I have a field (Varchar(255)) in a table which always have inputs like
12/29/2010 7:31:37 AM
12/30/2010 7:27:05 AM
1/3/2011 7:29:04 AM
Till Date, i was using the below formula to do a look up
select Convert(varchar, getdate(),101) as 'BacklogDate', Convert(varchar, getdate(),7) as 'Today'
however since the date i have in the table has 1/3/2011 7:29:04 AM, and the query i wrote populates, 01/03/2011, its not matching due to preceding zeros.
I need to have a query which does both with / without preceding zeros.