Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Date From Datetime (SQL)
Title: Date From Datetime Language: SQL
Description: returns the date only part of a datetime eg: '23 mar 2008 00:00:00.000' Views: 308
Author: Robert Baker Date Added: 11/24/2008
Copy Code   
declare @MyDate datetime
select @MyDate = GETDATE()

select convert(datetime,floor(convert(float, @MyDate)))