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.


        rows = Lists.newArrayList();


        TableRow row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 1), "1/1/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 1, 0, 0, 0, 0), "1/1/2011 00:00:00"));
        row.addCell(new TableCell(new NumberValue(222), "222"));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 2), "1/2/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 2, 3, 15, 0, 0)));
        row.addCell(new TableCell(NumberValue.getNullValue()));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 3), "1/3/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 3, 3, 15, 0, 0), "1/1/2011 03:15:00"));
        row.addCell(new TableCell(333));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 4)));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 4, 0, 0, 0, 0)));
        row.addCell(new TableCell(222));
        rows.add(row);


        testData.addRows(rows);

View Full Code Here

    }


    public void testAppendCellJson() {
        TableCell dateCell = new TableCell(new DateValue(2009, 1, 12));
        TableCell timeofdayCell = new TableCell(new TimeOfDayValue(12, 13, 14, 15));
        TableCell datetimeCell = new TableCell(new DateTimeValue(2009, 1, 12, 12, 13, 14, 15));
        TableCell booleanCell = new TableCell(true);
        TableCell numberCell = new TableCell(12.3);
        TableCell textCell = new TableCell("aba");


        JsonRenderer r = new JsonpRenderer();

View Full Code Here


        rows = Lists.newArrayList();


        TableRow row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 1), "1/1/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 1, 0, 0, 0, 0), "1/1/2011 00:00:00"));
        row.addCell(new TableCell(new NumberValue(222), "222"));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 2), "1/2/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 2, 3, 15, 0, 0)));
        row.addCell(new TableCell(NumberValue.getNullValue()));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 3), "1/3/2011"));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 3, 3, 15, 0, 0), "1/1/2011 03:15:00"));
        row.addCell(new TableCell(333));
        rows.add(row);


        row = new TableRow();
        row.addCell(new TableCell(new DateValue(2011, 1, 4)));
        row.addCell(new TableCell(new DateTimeValue(2011, 1, 4, 0, 0, 0, 0)));
        row.addCell(new TableCell(222));
        rows.add(row);


        testData.addRows(rows);

View Full Code Here


        TableRow row = new TableRow();
        row.addCell(new TableCell(new DateValue(2008, 5, 3)));
        row.addCell(new TableCell(new NumberValue(23)));
        row.addCell(new TableCell(new TimeOfDayValue(13, 12, 11)));
        row.addCell(new TableCell(new DateTimeValue(2007, 3, 4, 2, 6, 23, 120)));


        // Check date value.
        List<AbstractColumn> columns =
                Lists.newArrayList((AbstractColumn) new SimpleColumn("dateCol"));
        ScalarFunctionColumn sfc =

View Full Code Here

     *
     * @param values Ignored.
     * @return A DateTime value with the current time.
     */
    public Value evaluate(List<Value> values) {
        return new DateTimeValue(new GregorianCalendar(
                TimeZone.getTimeZone("GMT")));
    }

View Full Code Here

                            timestamp.getDate(), timestamp.getHours(), timestamp.getMinutes(),
                            timestamp.getSeconds());
                    // 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

                case TIMEOFDAY: {
                    dateTimeValue = new TimeOfDayValue(rowTime.getHourOfDay(), rowTime.getMinuteOfHour(), 0);
                    break;
                }
                default: {
                    dateTimeValue = new DateTimeValue(rowTime.getYear(), rowTime.getMonthOfYear()-1, rowTime.getDayOfMonth(), rowTime.getHourOfDay(), rowTime.getMinuteOfHour(), 0, 0);
                    break;
                }
            }
            row.addCell(new TableCell(dateTimeValue));

View Full Code Here

        second = Integer.parseInt(secondMilliSplit[0]);
        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));
    } catch (IllegalArgumentException e) {
      log.error(String.format(dateTimeMessage, s));

View Full Code Here

   * @param values Ignored.
   *
   * @return A DateTime value with the current time.
   */
  public Value evaluate(List<Value> values) {
    return new DateTimeValue(new GregorianCalendar(
        TimeZone.getTimeZone("GMT")));
  }

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

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.