public virtual void DateTimeAddMonthsTest()
{
var select = SqlDml.Select();
select.Columns.Add(SqlDml.DateTimeAddMonths(new DateTime(2001, 1, 1), 15));
select.Columns.Add(new DateTime(2002, 4, 1));
CompareColumnEquality(select);
}
public void Test014_5()
{
string nativeSql = @"select date('NOW', '+1 MONTHS') AS Days ";
SqlSelect select = SqlDml.Select();
select.Columns.Add(SqlDml.DateTimeAddMonths("NOW", 1 + 1), "Days");
Assert.IsTrue(CompareExecuteDataReader(nativeSql, select));
}
public void Test014_3()
{
SqlTableRef invoice = SqlDml.TableRef(schema.Tables["invoice"], "r");
SqlSelect select = SqlDml.Select(invoice);
select.Columns.Add(SqlDml.DateTimeAddMonths(invoice["PaymentDate"], 1 + 1), "TimeToToday");
select.Where = SqlDml.IsNotNull(invoice["PaymentDate"]);
Console.WriteLine(sqlDriver.Compile(select).GetCommandText());
}
public static SqlExpression DateTimeAddMonths(SqlExpression _this,
[Type(typeof(int))] SqlExpression value)
{
return(SqlDml.DateTimeAddMonths(_this, value));
}
public virtual void DateTimeAddMonthsTest()
{
CheckEquality(
SqlDml.DateTimeAddMonths(DefaultDateTime, AddMonthsConst),
DefaultDateTime.AddMonths(AddMonthsConst));
}
