Datetime format

how do开发者_运维百科 I convert a datetime to look like "dd/MM/yyyy" in a stored procedure?

---

do like

SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy

and see other format from here http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/