how to get date format dd/mm/yyyy

DECLARE @myDate DATETIME

SET @myDate = '2013/03/29'

SELECT @myDate AS MyDate
--returns: 2013/03/29 00:00:00.000

SELECT CONVERT(NVARCHAR(10), @myDate, 103) AS MyDate
--returns: 29/03/2013

select convert(char,_News_Date,103) as _News_Date 
From tbl 
Order by _News_Date asc

<asp:Label ID="lbldate" runat="server" Text='<%# formatDate(Eval("new_date","{0:MM/dd/yyyy}"))%>'></asp:Label>

protected string formatDate(string date)
        {
            if (date == null || date == "1/1/0001")
            {
                return "";
            }
            else
            {
                return date;
            }
        }

DateTime date = (DateTime.Now).ToString("yyyy/M/d"));