SQL Server query help... need to convert varchar to date -
i writing query fetch results values in column of varchar
type.. less '29/08/2010' (date)
my query:
select * employees column1 < '29/08/2010'
here column1 of varchar
type. using sql server 2005
is there way make possible..??
pls me.
thanks in advance
have tried
select * employees convert(datetime, column1, 103) > convert(datetime, '29/08/2010', 103)
Comments
Post a Comment