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

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -