Deveel.Data.SystemDateFunctionTests.Extract_Day C# (CSharp) Method

        public void Extract_Day()
        {
            var date = new SqlDateTime(1980, 02, 05, 18, 20, 11, 32);
            var value = Select("EXTRACT", SqlExpression.Constant(date), SqlExpression.Constant("day"));

            Assert.IsNotNull(value);
            Assert.IsFalse(value.IsNull);
            Assert.IsInstanceOf<NumericType>(value.Type);
            Assert.IsInstanceOf<SqlNumber>(value.Value);

            Assert.AreEqual(new SqlNumber(05), value.Value);
        }