Package com.facebook.presto.spi.type

Examples of com.facebook.presto.spi.type.SqlDate

219
220
221
222
223
224
225
    @Test
    public void testCastToDate()
            throws Exception
    {
        assertFunction("cast(TIMESTAMP '2001-1-22 03:04:05.321 +07:09' as date)",
                new SqlDate(new LocalDate(2001, 1, 22).toDateMidnight(getDateTimeZone(session.getTimeZoneKey())).getMillis(), session.getTimeZoneKey()));
    }
View Full Code Here
158
159
160
161
162
163
164
    @Test
    public void testCastToDate()
            throws Exception
    {
        assertFunction("cast(TIMESTAMP '2001-1-22 03:04:05.321' as date)", new SqlDate(new LocalDate(2001, 1, 22).toDateMidnight(DATE_TIME_ZONE).getMillis(), TIME_ZONE_KEY));
    }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
    }

    @Test
    public void testDatePlusInterval()
    {
        assertFunction("DATE '2001-1-22' + INTERVAL '3' day", new SqlDate(new DateTime(2001, 1, 25, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));
        assertFunction("INTERVAL '3' day + DATE '2001-1-22'", new SqlDate(new DateTime(2001, 1, 25, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));
        assertFunction("DATE '2001-1-22' + INTERVAL '3' month", new SqlDate(new DateTime(2001, 4, 22, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));
        assertFunction("INTERVAL '3' month + DATE '2001-1-22'", new SqlDate(new DateTime(2001, 4, 22, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));
        assertFunction("DATE '2001-1-22' + INTERVAL '3' year", new SqlDate(new DateTime(2004, 1, 22, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));
        assertFunction("INTERVAL '3' year + DATE '2001-1-22'", new SqlDate(new DateTime(2004, 1, 22, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));

        try {
            functionAssertions.tryEvaluate("DATE '2001-1-22' + INTERVAL '3' hour");
            fail("Expected IllegalArgumentException");
        }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
    }

    @Test
    public void testDateMinusInterval()
    {
        assertFunction("DATE '2001-1-22' - INTERVAL '3' day", new SqlDate(new DateTime(2001, 1, 19, 0, 0, 0, 0, TIME_ZONE).getMillis(), TIME_ZONE_KEY));

        try {
            functionAssertions.tryEvaluate("DATE '2001-1-22' - INTERVAL '3' hour");
            fail("Expected IllegalArgumentException");
        }
View Full Code Here
57
58
59
60
61
62
63
    @Test
    public void testLiteral()
            throws Exception
    {
        assertFunction("DATE '2001-1-22'", new SqlDate(new LocalDate(2001, 1, 22).toDateMidnight(getDateTimeZone(TIME_ZONE_KEY)).getMillis(), TIME_ZONE_KEY));
    }
View Full Code Here
169
170
171
172
173
174
175
    @Test
    public void testGreatest()
            throws Exception
    {
        assertFunction("greatest(DATE '2013-03-30', DATE '2012-05-23')", new SqlDate(new LocalDate(2013, 3, 30).toDateMidnight(getDateTimeZone(TIME_ZONE_KEY)).getMillis(), TIME_ZONE_KEY));
    }
View Full Code Here
176
177
178
179
180
181
182
    @Test
    public void testLeast()
            throws Exception
    {
        assertFunction("least(DATE '2013-03-30', DATE '2012-05-23')", new SqlDate(new LocalDate(2012, 5, 23).toDateMidnight(getDateTimeZone(TIME_ZONE_KEY)).getMillis(), TIME_ZONE_KEY));
    }
View Full Code Here
668
669
670
671
672
673
674
        functionAssertions.assertFunction(projection, expected);
    }

    private SqlDate toDate(long milliseconds)
    {
        return new SqlDate(milliseconds, session.getTimeZoneKey());
    }
View Full Code Here
673
674
675
676
677
678
679
        return new SqlDate(milliseconds, session.getTimeZoneKey());
    }

    private SqlDate toDate(DateTime dateDate)
    {
        return new SqlDate(dateDate.getMillis(), session.getTimeZoneKey());
    }
View Full Code Here
651
652
653
654
655
656
657
        functionAssertions.assertFunction(projection, expected);
    }

    private SqlDate toDate(long milliseconds)
    {
        return new SqlDate(milliseconds, session.getTimeZoneKey());
    }
View Full Code Here
TOP

Related Classes of com.facebook.presto.spi.type.SqlDate

  • com.facebook.presto.hive.AbstractTestHiveClient
  • com.facebook.presto.operator.scalar.TestDateTimeFunctions
  • com.facebook.presto.type.TestDate
  • com.facebook.presto.type.TestDateTimeOperators
  • com.facebook.presto.type.TestTimestamp
  • com.facebook.presto.type.TestTimestampWithTimeZone
  • java.text.SimpleDateFormat
  • java.util.Date
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.