/** Example of running a query with timestamp query parameters. */ public void runQueryWithTimestampParameters() throws InterruptedException { // [START bigquery_query_params_timestamps] // BigQuery bigquery = BigQueryOptions.getDefaultInstance().getService(); DateTime timestamp = new DateTime(2016, 12, 7, 8, 0, 0, DateTimeZone.UTC); String query = "SELECT TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR);"; // Note: Standard SQL is required to use query parameters. QueryJobConfiguration queryConfig = QueryJobConfiguration.newBuilder(query) .addNamedParameter( "ts_value", QueryParameterValue.timestamp( // Timestamp takes microseconds since 1970-01-01T00:00:00 UTC timestamp.getMillis() * 1000)) .build(); // Print the results. DateTimeFormatter formatter = ISODateTimeFormat.dateTimeNoMillis().withZoneUTC(); for (FieldValueList row : bigquery.query(queryConfig).iterateAll()) { System.out.printf( "%s\n", formatter.print( new DateTime( // Timestamp values are returned in microseconds since 1970-01-01T00:00:00 UTC, // but org.joda.time.DateTime constructor accepts times in milliseconds. row.get(0).getTimestampValue() / 1000, DateTimeZone.UTC))); System.out.printf("\n"); } // [END bigquery_query_params_timestamps] }
Assert.assertThat(ISO_INSTANT.format(withJsr310.getTs()), is(ISODateTimeFormat.dateTimeNoMillis().print(withJoda.getTs()))); Assert.assertThat(withJsr310.getDec(), comparesEqualTo(withJoda.getDec()));
.withZone(DateTimeZone.UTC) .parseDateTime(arcDateString) .toString(ISODateTimeFormat.dateTimeNoMillis()); recordInfo.setCreate14DigitDate(warcDateString);
formatter = ISODateTimeFormat.dateTime(); } else if ("dateTimeNoMillis".equals(input) || "date_time_no_millis".equals(input)) { formatter = ISODateTimeFormat.dateTimeNoMillis(); } else if ("hour".equals(input)) { formatter = ISODateTimeFormat.hour();
@Override protected DateTimeFormatter isoFormatter() { return ISODateTimeFormat.dateTimeNoMillis(); }
@Override protected DateTimeFormatter isoFormatter() { return ISODateTimeFormat.dateTimeNoMillis(); }
/** * @param date */ protected static String formatDate(DateTime date) { return ISODateTimeFormat.dateTimeNoMillis().print(date); }
public static String dateToString(Date date){ DateTimeFormatter fmt = ISODateTimeFormat.dateTimeNoMillis(); DateTime dateTime = new DateTime(date); return fmt.print(dateTime); } }
public static Date stringToDate(String dateString){ DateTimeFormatter fmt = ISODateTimeFormat.dateTimeNoMillis(); return fmt.parseDateTime(dateString).toDate(); }
/** * Sets a parameter on the query. This should match up to a ? in the * query template provided. note: this will add a DateTime to the query. * @param param */ public ArtificerClientQuery parameter(Calendar param) { String val = ISODateTimeFormat.dateTimeNoMillis().print(new DateTime(param)); replacementParams.add("'" + val + "'"); return this; }
/** {@inheritDoc} */ public DateTime fromString(String value) { try { return ISODateTimeFormat.dateTimeNoMillis().parseDateTime(value); } catch (IllegalArgumentException e) { return ISODateTimeFormat.dateTime().parseDateTime(value); } }
/** * Sets a parameter on the query. This should match up to a ? in the * query template provided. note: this will add a DateTime to the query. * @param param */ public SrampClientQuery parameter(Calendar param) { String val = ISODateTimeFormat.dateTimeNoMillis().print(new DateTime(param)); replacementParams.add("'" + val + "'"); //$NON-NLS-1$ //$NON-NLS-2$ return this; }
@Override public String toString() { return "\"ISODate(" + ISODateTimeFormat.dateTimeNoMillis().withZone(DateTimeZone.UTC).print(literal.getTime()) + ")\""; } }
public List<DateTimeFormatter> getDateFormatters() { List<DateTimeFormatter> list = new ArrayList<DateTimeFormatter>(); list.add(ISODateTimeFormat.dateTime()); list.add(ISODateTimeFormat.dateTimeNoMillis()); return list; }
public String getFormatedTimeWithOffset(double simulationTime) { DateTime dateTime = new DateTime(timeOffsetMillis + Math.round(1000 * simulationTime), DateTimeZone.UTC); return ISODateTimeFormat.dateTimeNoMillis().print(dateTime); }
private DateTime convertStringToJodaDateTime(final String theDate) { if (StringUtils.isEmpty(theDate)) { return null; } final DateTimeFormatter dateFormat = ISODateTimeFormat.dateTimeNoMillis(); return new DateTime(dateFormat.parseDateTime(theDate).toDate()); } }
@Override protected CharSequence safeApply(final ReadableInstant time, final Options options) { boolean includeMillis = options.param(1, false); if (includeMillis) { return ISODateTimeFormat.dateTime().print(time); } else { return ISODateTimeFormat.dateTimeNoMillis().print(time); } }
/** * Returns a formatted String representing the crawled date. * * @param waybackDate * @return */ protected static String parseCrawlDate( String waybackDate ) { DateTimeFormatter iso_df = ISODateTimeFormat.dateTimeNoMillis() .withZone(DateTimeZone.UTC); return iso_df.print(new org.joda.time.DateTime( getWaybackDate(waybackDate))); }
/** * Returns a formatted String representing the crawled date. * * @param waybackDate * @return */ protected static String parseCrawlDate( String waybackDate ) { DateTimeFormatter iso_df = ISODateTimeFormat.dateTimeNoMillis() .withZone(DateTimeZone.UTC); return iso_df.print(new org.joda.time.DateTime( getWaybackDate(waybackDate))); }
private static boolean testNoMillisFormat(String time) { DateTimeFormatter formatNoMillis = ISODateTimeFormat.dateTimeNoMillis().withZoneUTC(); try { formatNoMillis.parseDateTime(time); return true; } catch (IllegalArgumentException e) { return false; } }