Example #1
0
        public void testTimeFormat()
        {
            var dialect = new Oracle11Dialect();
            var time    = new TimeSpan(1, 23, 45);

            dialect.ToLogFormat(time).Is("time'01:23:45'");
        }
Example #2
0
        public void testDateFormat()
        {
            var dialect = new Oracle11Dialect();
            var date    = new DateTime(2009, 1, 23);

            dialect.ToLogFormatDateOnly(date).Is("date'2009-01-23'");
        }
Example #3
0
        public void testTimestampFormat()
        {
            var dialect  = new Oracle11Dialect();
            var datetime = new DateTime(2009, 1, 23, 1, 23, 45, 123);

            dialect.ToLogFormat(datetime).Is("timestamp'2009-01-23 01:23:45.123'");

            var datetimeoffset = new DateTimeOffset(2009, 1, 23, 1, 23, 45, 123, TimeSpan.Zero);

            dialect.ToLogFormat(datetimeoffset).Is("timestamp'2009-01-23 01:23:45.123'");
        }
Example #4
0
        public void testExpressionFunctions_prefix_escapeWithBackslash()
        {
            var dialect = new Oracle11Dialect();

            dialect.StartsWith("a\\a%a_a%a_", '\\').Is("a\\\\a\\%a\\_a\\%a\\_%");
        }
Example #5
0
        public void testExpressionFunctions_prefix_escape()
        {
            var dialect = new Oracle11Dialect();

            dialect.StartsWith("a!a%a_a%a_", '!').Is("a!!a!%a!_a!%a!_%");
        }
Example #6
0
        public void testExpressionFunctions_prefix()
        {
            var dialect = new Oracle11Dialect();

            dialect.StartsWith("a$a%a_a%a_").Is("a$$a$%a$_a$%a$_%");
        }