Where clause with date type. Need help

compviscompvis Posts: 13
edited April 1, 2011 8:04AM in SQL Comparison SDK Previous Versions
hi,

I have a table with a field that has data type is date. So how can i filter data in table by date type, like:
TableMappings mappings = new TableMappings();
sourcedb.Register(sourcecn, Options.Default);
targetdb.Register(targetcn, Options.Default);
mappings.CreateMappings(sourcedb.Tables, targetdb.Tables);

foreach(TableMapping tbm in mappings)
{
    if (tbm.Obj1.Name == "DQP_T3") 
    {
           tbm.Include = true;
           tbm.Where = new RedGate.SQLDataCompare.Engine.WhereClause("Date >= 10/10/2000 && Date <= 10/10/2011");
     }
     else
     {
           tbm.Include = false;
     }
}
Thanks
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    That looks reasonable, except as it's a SQL clause, you need to use AND rather than && - for instance:

    tbm.Where = new RedGate.SQLDataCompare.Engine.WhereClause("Date >= 10/10/2000 AND Date <= 10/10/2011");

    Does that help? Also, to avoid any potential confusion over date formats you may want to specify the dates as yyyy-mm-dd.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.