26 July 2014

Get Current Date in SQL Server 2005

get Only Date from datetime in SQL Server 2005
GETDATE()
CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly