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)); }