Home » T-SQL » T-SQL: How to get only Date from DateTime? 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())) Posted on Thursday, January 3, 2008 by Viktar Karpach | Comments (1) | Add Comment Comments VeryGOOD VERY GOOD Posted on 6/26/2008 2:47:04 AM by from vitenam # New Comment Your Name: Email (for internal use only): Comment: Code above: