Home Forums SQL Server 7,2000 Replication How to Change the default date format in sqlserver 2005 RE: How to Change the default date format in sqlserver 2005

  • November 19, 2009 at 7:18 am

    #1081539

    Try this:

    SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS MyDate

    I hope it will be helpful for you.