SQL Server - server date - Asked By Tejas Deshpande on 15-Dec-05 01:02 AM

i want to retrieve server date. how it should be retrieved using SQL server may be using Stored procedure .

GetDate - Asked By Sathish S on 15-Dec-05 01:25 AM

function would give you current date and time.
SELECT getdate()

thanks it woks - Asked By Tejas Deshpande on 15-Dec-05 01:48 AM

thank u it is working

Link - Asked By F Cali on 15-Dec-05 02:30 PM

Hi Tejas,

Here's a link on frequently asked questions about dates in SQL Server, which contains your question: