Search for
in snippet title/description
in snippet text
Browse Code
Add-Ins
Blog
Language Feeds
Service Stats
FAQs
Feedback
About
Manage Your Code
Login
Register
Snippet: Date portion of DateTime (SQL)
Title:
Date portion of DateTime
Language:
SQL
Description:
Get only the date portion of DateTime in T-SQL http://ayende.com/Blog/2006/02/16/JustDateStripingTheTimePartFromDatetimeVariables.aspx
Views:
533
Author:
Filip K
Date Added:
9/23/2008
Copy
Code
declare @date DATETIME select @date = Getdate() select DATEADD(dd, 0, DATEDIFF(dd, 0, @date))
declare @date DATETIME select @date = Getdate() select DATEADD(dd, 0, DATEDIFF(dd, 0, @date))