SYSDATETIME() will give you current date and time
CAST(SYSDATETIME() as date) will give you current date only
What are you referring to with 'Current Date'?
What do you mean by SQL Server Date format?
What sort of 'Convert'?
Far away is close at hand in the images of elsewhere.
Anon.