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.
use 
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:

http://www.sql-server-helper.com/faq/dates-p01.aspx