• 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.