sql date

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 Tunde12y ago

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

Shweta Lodha12y ago

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