eXtreme Programming
XP for the programmer
12 October 2010
Get only the Date Part of a DateTime
To get only the Date Part of a DateTime in an efficient way, use the following code:
SELECT
CAST
(FLOOR(
CAST
( GETDATE()
AS
FLOAT
))
AS
DATETIME)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment