i want to retrieve server date. how it should be retrieved using SQL server may be using Stored procedure .
function would give you current date and time.
thank u it is working
Here's a link on frequently asked questions about dates in SQL Server, which contains your question: