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