Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: get date part of variable with datetime type (SQL)
Title: get date part of variable with datetime type Language: SQL
Description: get date part of variable with datetime type in sqlserver Views: 174
Author: Jason Huo Date Added: 12/1/2008
Copy Code   
DECLARE @dt DATETIME
SET @dt = GetDate()
SELECT @dt
SELECT CAST(FLOOR(CAST(@dt AS FLOAT )) AS DATETIME)

-- 2008-12-01 16:20:00.120
-- 2008-12-01 00:00:00.000