public void CompareYearToMonthToNull() { var value1 = new SqlYearToMonth(22); var value2 = SqlYearToMonth.Null; var result = value1.CompareTo(value2); Assert.AreEqual(1, result); }
public void YearToMonthFromInteger(int months, int expectedYears) { var value = new SqlYearToMonth(months); Assert.IsNotNull(value); Assert.IsFalse(value.IsNull); Assert.AreEqual(expectedYears, (int)value.TotalYears); }
public SqlDateTime Subtract(SqlYearToMonth interval) { if (IsNull) { return(Null); } if (interval.IsNull) { return(this); } var result = value.Value.AddMonths(-interval.TotalMonths); return(new SqlDateTime(result.Ticks)); }
public void Subtract_MonthSpan() { var value = new SqlDateTime(2001, 11, 03, 10, 22, 03, 0); var ms = new SqlYearToMonth(1, 3); var result = new SqlDateTime(); Assert.DoesNotThrow(() => result = value.Subtract(ms)); Assert.IsFalse(result.IsNull); Assert.AreEqual(2000, result.Year); Assert.AreEqual(08, result.Month); Assert.AreEqual(10, result.Hour); Assert.AreEqual(22, result.Minute); Assert.AreEqual(03, result.Second); Assert.AreEqual(0, result.Millisecond); }