sql server - To get date from datetime in sql

Question

I have datecreated field in a table. It contains value as "2009-12-30 11:47:20:297" I have a query like this:

select * 
  from table 
 where DateCreated = getdate()

Although one row exists with today's date, I am not getting that row while executing above query. Can anybody help?

Answer 1

You can use something like this with Sql Server

CREATE FUNCTION [dbo].[udf_DateOnly](@DateTime DATETIME)
RETURNS DATETIME
AS
BEGIN
    RETURN DATEADD(dd,0, DATEDIFF(dd,0,@DateTime))
END

This line

DATEADD(dd,0, DATEDIFF(dd,0,@DateTime))

will strip out the Date portion.