reply fast as possible?

Dear try
as per requirment


Select Convert(Varchar,Getdate(),101)  -  MM/dd/yyyy
Select Convert(Varchar,Getdate(),103)  -  dd/MM/yyyy


For MM/dd/yyyy

Select Convert(Varchar,Getdate(),1)


dd/MM/yyyy
Select Convert(Varchar,Getdate(),3)


hh:mm:ss
Select Convert(Varchar,Getdate(),2)

try

Select Convert(Varchar,Getdate(),103)

Hi,
Use the below code
select convert(smalldatetime,'14/05/2012 20:20:00',101)
it will return 15/04/2012 20:20:00