Convert a SQL Server datetime to a shorter date format

Have a look at CONVERT. The 3rd parameter is the date time style you want to convert to.

e.g.

SELECT CONVERT(VARCHAR(10), GETDATE(), 103) -- dd/MM/yyyy format

Try this:

print cast(getdate() as date )

If you need the result in a date format you can use:

Select Convert(DateTime, Convert(VarChar, GetDate(), 101))