Examples of com.google.visualization.datasource.datatable.value.DateTimeValue

Package com.google.visualization.datasource.datatable.value

Examples of com.google.visualization.datasource.datatable.value.DateTimeValue

com.google.visualization.datasource.datatable.value.DateTimeValue
A value of type date-time. Used to represent a specific day in a given year as well as a specific time during that day. This differs from {@link DateValue}, which represents only a specific day in a given year. DateTime is represented internally by a GregorianCalendar. The calendar is immutable and is kept only for validation of the input. @author Hillel M.

    TableRow row = new TableRow();
    row.addCell(new TableCell(new TextValue("aaa"), "aaa"));
    row.addCell(new TableCell(new NumberValue(222), "222"));
    row.addCell(new TableCell(BooleanValue.TRUE, "true"));
    row.addCell(new TableCell(new DateValue(2009, 1, 1), "2009-02-01"));
    row.addCell(new TableCell(new DateTimeValue(2009, 1, 1, 12, 14, 1, 0), "2009-02-01 12:14:01"));
    row.addCell(new TableCell(new TimeOfDayValue(12, 14, 1), "12:14:01"));
    rows.add(row);
    
    row = new TableRow();
    row.addCell(new TableCell(new TextValue("aaa"), "a,aa"));
    row.addCell(new TableCell(new NumberValue(222), "2,22"));
    row.addCell(new TableCell(BooleanValue.TRUE, "true,"));
    row.addCell(new TableCell(new DateValue(2009, 1, 1), "2009-02-01"));
    row.addCell(new TableCell(new DateTimeValue(2009, 1, 1, 12, 14, 1, 0), "2009-02-01 12,14,01"));
    row.addCell(new TableCell(new TimeOfDayValue(12, 14, 1), "12:14:01"));
    rows.add(row);
    
    testData.addRows(rows);

View Full Code Here

        TableRow row = new TableRow();
        row.addCell(new TableCell(new TextValue("aaa"), "aaa"));
        row.addCell(new TableCell(new NumberValue(222), "222"));
        row.addCell(new TableCell(BooleanValue.TRUE, "true"));
        row.addCell(new TableCell(new DateValue(2009, 1, 1), "2009-02-01"));
        row.addCell(new TableCell(new DateTimeValue(2009, 1, 1, 12, 14, 1, 0), "2009-02-01 12:14:01"));
        row.addCell(new TableCell(new TimeOfDayValue(12, 14, 1), "12:14:01"));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new TextValue("aaa"), "a,aa"));
        row.addCell(new TableCell(new NumberValue(222), "2,22"));
        row.addCell(new TableCell(BooleanValue.TRUE, "true,"));
        row.addCell(new TableCell(new DateValue(2009, 1, 1), "2009-02-01"));
        row.addCell(new TableCell(new DateTimeValue(2009, 1, 1, 12, 14, 1, 0), "2009-02-01 12,14,01"));
        row.addCell(new TableCell(new TimeOfDayValue(12, 14, 1), "12:14:01"));
        rows.add(row);


        testData.addRows(rows);

View Full Code Here

        row.addCell(new TableCell("aaa"));
        row.addCell(new TableCell(222));
        row.addCell(new TableCell(false));
        row.addCell(new TableCell(new DateValue(2001, 10, 14)));
        row.addCell(new TableCell(new TimeOfDayValue(12, 11, 13, 14)));
        row.addCell(new TableCell(new DateTimeValue(2000, 10, 1, 1, 10, 23, 432)));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new TextValue("ccc"), "$ccc"));
        row.addCell(new TableCell(111));
        row.addCell(new TableCell(true));
        row.addCell(new TableCell(new DateValue(2001, 1, 14)));
        row.addCell(new TableCell(new TimeOfDayValue(12, 30, 13, 14)));
        row.addCell(new TableCell(new DateTimeValue(1000, 11, 1, 1, 10, 23, 432)));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell("bbb"));
        row.addCell(new TableCell(3));
        row.addCell(new TableCell(true));
        row.addCell(new TableCell(new DateValue(2012, 2, 14)));
        row.addCell(new TableCell(new TimeOfDayValue(12, 11, 3, 14)));
        row.addCell(new TableCell(new DateTimeValue(2000, 1, 1, 1, 10, 31, 4)));
        rows.add(row);


        row = new TableRow();
        row.addCell("ddd");
        row.addCell(222);
        row.addCell(false);
        row.addCell(new DateValue(1997, 5, 5));
        row.addCell(new TimeOfDayValue(12, 15, 15, 14));
        row.addCell(new DateTimeValue(3100, 1, 2, 15, 15, 1, 0));
        rows.add(row);


        testData.addRows(rows);
    }

View Full Code Here

        assertEquals(testData.getRow(4).getCell(0).getValue().compareTo(new TextValue("blah")), 0);
        assertEquals(testData.getRow(4).getCell(1).getValue().compareTo(new NumberValue(5)), 0);
        assertEquals(testData.getRow(4).getCell(2).getValue().compareTo(BooleanValue.TRUE), 0);
        assertEquals(testData.getRow(4).getCell(3).getValue().compareTo(new DateValue(c1)), 0);
        assertEquals(testData.getRow(4).getCell(4).getValue().compareTo(new TimeOfDayValue(c2)), 0);
        assertEquals(testData.getRow(4).getCell(5).getValue().compareTo(new DateTimeValue(c2)), 0);
    }

View Full Code Here

              new GregorianCalendar(TimeZone.getTimeZone("GMT"));
          gc.setTime(timestamp);
          // Set the milliseconds explicitly, as they are not saved in the
          // underlying date.
          gc.set(Calendar.MILLISECOND, timestamp.getNanos() / 1000000);
          value = new DateTimeValue(gc);
        }
        break;
      case TIMEOFDAY:
        Time time = rs.getTime(column);
        // If time is null it is handled later.

View Full Code Here

                milli = Integer.parseInt(secondMilliSplit[1]);
            }
            else {
                second = Integer.parseInt(timeSplit[2]);
            }
            return new DateTimeValue(year, month, day, hour, minute, second, milli);
        }
        catch(NumberFormatException e) {
            log.error(String.format(dateTimeMessage, s));
            throw new InvalidQueryException(String.format(dateTimeMessage, s));
        }

View Full Code Here

        Query query = QueryBuilder.getInstance().parseQuery("WHERE c1 > DATE '2006-08-23'");
        assertEquals(new DateValue(2006, 7, 23),
                ((ColumnValueFilter) query.getFilter()).getValue());
        query = QueryBuilder.getInstance().parseQuery(
                "WHERE c1 = DaTeTiMe '2007-01-30 15:33:22.432'");
        assertEquals(new DateTimeValue(2007, 0, 30, 15, 33, 22, 432),
                ((ColumnValueFilter) query.getFilter()).getValue());
        query = QueryBuilder.getInstance().parseQuery(
                "WHERE c1 = timesTaMP '2007-01-30 15:33:22.432'");
        assertEquals(new DateTimeValue(2007, 0, 30, 15, 33, 22, 432),
                ((ColumnValueFilter) query.getFilter()).getValue());
        query = QueryBuilder.getInstance().parseQuery("WHERE c1 != TimeOfDay '15:33:22'");
        assertEquals(new TimeOfDayValue(15, 33, 22),
                ((ColumnValueFilter) query.getFilter()).getValue());
    }

View Full Code Here

                    uFormat.format(new TimeOfDayValue(2, 59, 12, 123).getObjectToFormat());
                    break;
                case DATETIME:
                    uFormat = new SimpleDateFormat(pattern, locale);
                    ((SimpleDateFormat) uFormat).setTimeZone(TimeZone.getTimeZone("GMT"));
                    uFormat.format(new DateTimeValue(1995, 7, 3, 2, 59, 12, 123).getObjectToFormat());
                    break;
                case NUMBER:
                    DecimalFormatSymbols symbols = new DecimalFormatSymbols(locale);
                    uFormat = new DecimalFormat(pattern, symbols);
                    uFormat.format(new NumberValue(-12.3).getObjectToFormat());

View Full Code Here

     */
    private DateTimeValue parseDateTime(String val) throws ParseException {
        Date date = ((SimpleDateFormat) uFormat).parse(val);
        GregorianCalendar gc = new GregorianCalendar(TimeZone.getTimeZone("GMT"));
        gc.setTime(date);
        return new DateTimeValue(gc);
    }

View Full Code Here

        DateDiff dateDiff = DateDiff.getInstance();
        List<Value> valuesList1 =
                Lists.<Value>newArrayList(new DateValue(2008, 1, 13),
                        new DateValue(2008, 2, 13));
        List<Value> valuesList2 = Lists.newArrayList(new DateValue(2008, 1, 13),
                new DateTimeValue(2008, 1, 13, 9, 12, 22, 333));
        List<Value> valuesList3 =
                Lists.<Value>newArrayList(new DateTimeValue(2008, 6, 1, 9, 12, 22, 333),
                        new DateTimeValue(2008, 10, 1, 9, 12, 22, 333));
        List<Value> valuesList4 = Lists.<Value>newArrayList(new DateTimeValue(
                2008, 10, 1, 9, 12, 22, 333),
                new DateTimeValue(2008, 6, 1, 9, 12, 20, 333));


        assertEquals(new NumberValue(-29), dateDiff.evaluate(valuesList1));
        assertEquals(new NumberValue(0), dateDiff.evaluate(valuesList2));
        assertEquals(new NumberValue(-123), dateDiff.evaluate(valuesList3));
        assertEquals(new NumberValue(123), dateDiff.evaluate(valuesList4));

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of com.google.visualization.datasource.datatable.value.DateTimeValue

com.google.visualization.datasource.datatable.DataTableTest

com.google.visualization.datasource.datatable.ValueFormatter

com.google.visualization.datasource.datatable.ValueFormatterTest

com.google.visualization.datasource.query.mocks.MockDataSource

com.google.visualization.datasource.query.parser.ParserUtils

com.google.visualization.datasource.query.parser.QueryBuilderTest

com.google.visualization.datasource.query.scalarfunction.CurrentDateTime

com.google.visualization.datasource.query.scalarfunction.DateDiffTest

com.google.visualization.datasource.query.scalarfunction.TimeComponentExtractorTest

com.google.visualization.datasource.query.scalarfunction.ToDateTest

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.