Need Help With Date 1

[krishnaa123]

Hi all,
In Oracle while selecting a date we can query in this way for example trunc(col name,dd/mm/yyyy) = trun(sysdate)
how do I do that in SQL Server I am using 2000.

Thanks in advance,
krishnaa.

 

[ronnetp]

I hope this is what you need
select convert(varchar(20),getdate(),110)

 

[krishnaa123]

Hi Ronnetp,
Thaks a lot this works.

thnaks,
y.p.krishnaa.