using System;
using System.Data;
using System.Text;

namespace Test
{
  
  class Program
  {
    static void Main(string[] args)
    {

      DataTable dt = new DataTable();
      dt.Columns.Add("date", typeof(DateTime));

      dt.Rows.Add(new object[] { DateTime.Today });
      dt.Rows.Add(new object[] { DateTime.Today.AddDays( 1 ) });
      dt.Rows.Add(new object[] { DateTime.Today.AddDays( 2 ) });
      dt.Rows.Add(new object[] { DateTime.Today.AddDays( 3 ) });
      dt.Rows.Add(new object[] { DateTime.Today.AddDays( 4 ) });
      dt.Rows.Add(new object[] { DateTime.Today });

      string filter = string.Format("date = '{0}'", DateTime.Today);

      DataRow[] rows = dt.Select(filter);

    }
  }
}