Total Pageviews

Thursday, August 19, 2010

SQL Server - Ripping time part

-- Get current date (without time) as string:
SELECT CONVERT( CHAR(8), GetDate(), 112)

-- Get current date (without time) as date:
SELECT CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME)

No comments:

Post a Comment