sql date

Question

the default date in sql server 2008 is yy/dd/mm. i want sql code to make the date dd/mm/yy. Thanks

Shweta Lodha · Answer

It is up to your need. You can either print the result on the output window or you can store it in a variable. Tutorial on writing SQL queries: http://technet.microsoft.com/en-us/library/bb264565(v=sql.90).aspx

louis Tunde · Answer

thanks jain. please can you write a few query so that i can know where to place the code you provided

Shweta Lodha · Answer

SELECT CONVERT(VARCHAR(8) GETDATE() 1) AS [DD/MM/YY]