T-SQL: How to get only Date from DateTime?

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))


Here how you can get time only from DateTime field:


SELECT DATEADD(day, 0, -DATEDIFF(day, 0, GETDATE()))

 


Thursday, January 03, 2008 | Comments (1) | Add Comment

Comments

Gravatar

VeryGOOD

VERY GOOD
6/26/2008 2:47:04 AM | by from vitenam

New Comment

Your Name:
Email (for internal use only):
Subject:
Comment:
 
Code above:

Categories

Recent Tweets

Valid XHTML 1.0 Transitional