the perfect query to rply your question is

select convert(varchar,getdate(),101)

you can get other formats by changing last parameter

Rahul arora mca 04/01

israna, panipat

hry,INDIA

Dbcc Shrinkfile(logfile_name,1)

this will help certainly

rahul arora mca 04/01

ncce israna,panipat

hry,india