Untitled

Parse DateTime Parameter
SELECT id FROM database WHERE added like @p1

SELECT id
    FROM database
    WHERE Datepart(yy, added) = Datepart(yy, @p1)
      AND  Datepart(mm, added) = Datepart(mm, @p1)
      AND Datepart(dd, added) = Datepart(dd, @p1)

SELECT id FROM database WHERE added >= '2012-01-26' and added < '2012-01-27'

DateTime dt;
string Temp1 = "Your Date";
if (DateTime.TryParse(Temp1, out dt))
{
     // If it is a valid date
     string date = dt.ToShortDateString();
     string time = dt.ToShortTimeString();
}

SELECT id FROM database WHERE Datepart(dd, added) = Datepart(dd, @p1)

create table #temp
(
    dat datetime,
)

insert into #temp(dat)values(GETDATE())
insert into #temp(dat)values(GETDATE()+1)
insert into #temp(dat)values(GETDATE()+2)

select * from #temp where DATEPART(dd, dat) > 27
drop table #temp

DateTime MyDateTime = DateTime.Parse("12/31/2012",CultureInfo.CurrentCulture);

DateTime myDateTime;
if (DateTime.TryParse("12/31/2012",CultureInfo.CurrentCulture, out myDateTime)
{
   // do something with myDateTime...
}
else
{
    // do something about the value not being in the correct format
}

select id from database where cast(added as date) = cast(@p1 as date)