System.out.println("dateTime : " + dateTime.toString()); System.out.println("localDateTime : " + localDateTime.toString()); System.out.println("DateTimeZone : " + dateTimeZone.toString()); System.out.println("Year Difference : " + Years.yearsBetween(DateTime.parse(dob), dateTime).getYears());
granularity.getOrigin() == null ? null : granularity.getOrigin().getMillis() ), DruidExpression.stringLiteral(granularity.getTimeZone().toString()) ).stream().map(DruidExpression::fromExpression).collect(Collectors.toList()) );
granularity.getOrigin() == null ? null : granularity.getOrigin().getMillis() ), DruidExpression.stringLiteral(granularity.getTimeZone().toString())
@Test(groups = "slow", enabled = false) public void testWithGMTMinus20() throws SQLException { final LocalDate date1_1 = new LocalDate(2014, 10, 1, GregorianChronology.getInstance(DATE_TZ_MINUS_20_GMT)); // We chose a time such that it moves to next day final DateTime date2_1 = new DateTime(2014, 10, 1, 16, 48, 56, DATE_TZ_MINUS_20_GMT); insertData(date1_1, date2_1, date2_1); final FullOfDates result = readData(); assertEquals(result.getDate1().compareTo(date1_1), 0); assertEquals(result.getDate2().compareTo(date2_1), 0); assertEquals(result.getDate2().getZone().toString(), "UTC"); }
@Test(groups = "slow", enabled = false) public void testWithGMTPlus8() throws SQLException { final LocalDate date1_1 = new LocalDate(2014, 10, 1, GregorianChronology.getInstance(DATE_TZ_PLUS_8_GMT)); // We chose a time such that it moves to next day final DateTime date2_1 = new DateTime(2014, 10, 1, 22, 48, 56, DATE_TZ_PLUS_8_GMT); insertData(date1_1, date2_1, date2_1); final FullOfDates result = readData(); assertEquals(result.getDate1().compareTo(date1_1), 0); assertEquals(result.getDate2().compareTo(date2_1), 0); assertEquals(result.getDate2().getZone().toString(), "UTC"); }
private List<ChangedField> calculateChangedFields(final AccountModelDao oldData, final AccountModelDao newData, final DateTime changeDate) { final List<ChangedField> tmpChangedFields = new ArrayList<ChangedField>(); addIfValueChanged(tmpChangedFields, "externalKey", oldData.getExternalKey(), newData.getExternalKey(), changeDate); addIfValueChanged(tmpChangedFields, "email", oldData.getEmail(), newData.getEmail(), changeDate); addIfValueChanged(tmpChangedFields, "firstName", oldData.getName(), newData.getName(), changeDate); addIfValueChanged(tmpChangedFields, "currency", (oldData.getCurrency() != null) ? oldData.getCurrency().toString() : null, (newData.getCurrency() != null) ? newData.getCurrency().toString() : null, changeDate); addIfValueChanged(tmpChangedFields, "billCycleDayLocal", String.valueOf(oldData.getBillingCycleDayLocal()), String.valueOf(newData.getBillingCycleDayLocal()), changeDate); addIfValueChanged(tmpChangedFields, "paymentMethodId", (oldData.getPaymentMethodId() != null) ? oldData.getPaymentMethodId().toString() : null, (newData.getPaymentMethodId() != null) ? newData.getPaymentMethodId().toString() : null, changeDate); addIfValueChanged(tmpChangedFields, "locale", oldData.getLocale(), newData.getLocale(), changeDate); addIfValueChanged(tmpChangedFields, "timeZone", (oldData.getTimeZone() == null) ? null : oldData.getTimeZone().toString(), (newData.getTimeZone() == null) ? null : newData.getTimeZone().toString(), changeDate); addIfValueChanged(tmpChangedFields, "address1", oldData.getAddress1(), newData.getAddress1(), changeDate); addIfValueChanged(tmpChangedFields, "address2", oldData.getAddress2(), newData.getAddress2(), changeDate); addIfValueChanged(tmpChangedFields, "city", oldData.getCity(), newData.getCity(), changeDate); addIfValueChanged(tmpChangedFields, "stateOrProvince", oldData.getStateOrProvince(), newData.getStateOrProvince(), changeDate); addIfValueChanged(tmpChangedFields, "country", oldData.getCountry(), newData.getCountry(), changeDate); addIfValueChanged(tmpChangedFields, "postalCode", oldData.getPostalCode(), newData.getPostalCode(), changeDate); addIfValueChanged(tmpChangedFields, "phone", oldData.getPhone(), newData.getPhone(), changeDate); return tmpChangedFields; }
@Override protected void doXContentBody(XContentBuilder builder, Params params) throws IOException { if (dateHistogramInterval == null) { builder.field(Histogram.INTERVAL_FIELD.getPreferredName(), interval); } else { builder.field(Histogram.INTERVAL_FIELD.getPreferredName(), dateHistogramInterval.toString()); } if (timeZone != null) { builder.field("time_zone", timeZone.toString()); } }
@Override public final XContentBuilder internalXContent(XContentBuilder builder, Params params) throws IOException { builder.startObject(); if (field != null) { builder.field("field", field); } if (script != null) { builder.field("script", script); } if (missing != null) { builder.field("missing", missing); } if (format != null) { builder.field("format", format); } if (timeZone != null) { builder.field("time_zone", timeZone.toString()); } if (valueType != null) { builder.field("value_type", valueType.getPreferredName()); } doXContentBody(builder, params); builder.endObject(); return builder; }
@Override public String toNonNullValue(DateTimeZone value) { return value.toString(); } }
@Override public void apply(final int position, final PreparedStatement statement, final StatementContext ctx) throws SQLException { if (value != null) { statement.setString(position, value.toString()); } else { statement.setNull(position, Types.VARCHAR); } }
@Override public void apply(final int position, final PreparedStatement statement, final StatementContext ctx) throws SQLException { if (value != null) { statement.setString(position, value.toString()); } else { statement.setNull(position, Types.VARCHAR); } }
@Override public void apply(final int position, final PreparedStatement statement, final StatementContext ctx) throws SQLException { if (value != null) { statement.setString(position, value.toString()); } else { statement.setNull(position, Types.VARCHAR); } }
@Override public byte[] cacheKey() { return (period.toString() + ":" + chronology.getZone().toString()).getBytes(); }
public String getOutputTimezone() { if (!containsParameter(OUTPUT_TIMEZONE)) { return DEFAULT_OUTPUT_TIMEZONE; } String timezone = getAsString(OUTPUT_TIMEZONE); Set<String> availableIDs = DateTimeZone.getAvailableIDs(); DateTimeZone zone = availableIDs.contains(timezone) ? DateTimeZone.forID(timezone) : DateTimeZone.UTC; return zone.toString(); }
public TimeFieldFormat(String timeZone, String locale, String filteringType) { try { this.timeZone = timeZone == null ? EngineQueryProperties.getDefaultTimezone() : DateTimeZone.forID(timeZone).toString(); } catch (Exception e) { throw new BadRequestException("Invalid timezone ID : " + e.getMessage()); } try { this.locale = locale == null ? EngineQueryProperties.getDefaultLocale() : new Locale(locale).getLanguage(); } catch (Exception e) { throw new BadRequestException("Invalid local value : " + e.getMessage()); } this.filteringType = EnumUtils.getUpperCaseEnum(FilteringType.class, filteringType); }
@Override public byte[] getCacheKey() { return StringUtils.toUtf8(getPeriod().toString() + ":" + getTimeZone().toString() + ":" + getOrigin()); }
@Test(groups = "slow", enabled = false) public void testWithGMTPlus8() throws SQLException { final LocalDate date1_1 = new LocalDate(2014, 10, 1, GregorianChronology.getInstance(DATE_TZ_PLUS_8_GMT)); // We chose a time such that it moves to next day final DateTime date2_1 = new DateTime(2014, 10, 1, 22, 48, 56, DATE_TZ_PLUS_8_GMT); insertData(date1_1, date2_1, date2_1); final FullOfDates result = readData(); assertEquals(result.getDate1().compareTo(date1_1), 0); assertEquals(result.getDate2().compareTo(date2_1), 0); assertEquals(result.getDate2().getZone().toString(), "UTC"); }
@Test(groups = "slow", enabled = false) public void testWithGMTMinus20() throws SQLException { final LocalDate date1_1 = new LocalDate(2014, 10, 1, GregorianChronology.getInstance(DATE_TZ_MINUS_20_GMT)); // We chose a time such that it moves to next day final DateTime date2_1 = new DateTime(2014, 10, 1, 16, 48, 56, DATE_TZ_MINUS_20_GMT); insertData(date1_1, date2_1, date2_1); final FullOfDates result = readData(); assertEquals(result.getDate1().compareTo(date1_1), 0); assertEquals(result.getDate2().compareTo(date2_1), 0); assertEquals(result.getDate2().getZone().toString(), "UTC"); }