Hi friends pls find soln..
I want to retrieve only date and to disp in my asp app from stored datetime in my databsae sql server ...
whan i make use of this query
select CONVERT(varchar(10),getdate(),111)
retrieves current date not the stored date of db..
Join Hands Change lives
Thanks & Regards
Straight Edge Society