format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
timestamp.getHours(), timestamp.getMinutes(), timestamp.getSeconds(), timestamp.getNanos());
Assert.assertEquals(sqlTimestamp.getHours(), s.getSqlTimestamp().getHours()); Assert.assertEquals(sqlTimestamp.getMinutes(), s.getSqlTimestamp().getMinutes()); Assert.assertEquals(sqlTimestamp.getSeconds(), s.getSqlTimestamp().getSeconds());
Assert.assertEquals(sqlTimestamp.getHours(), s.getSqlTimestamp().getHours()); Assert.assertEquals(sqlTimestamp.getMinutes(), s.getSqlTimestamp().getMinutes()); Assert.assertEquals(sqlTimestamp.getSeconds(), s.getSqlTimestamp().getSeconds());
Assert.assertEquals(sqlTimestamp.getHours(), s.getSqlTimestamp().getHours()); Assert.assertEquals(sqlTimestamp.getMinutes(), s.getSqlTimestamp().getMinutes()); Assert.assertEquals(sqlTimestamp.getSeconds(), s.getSqlTimestamp().getSeconds());
Assert.assertEquals(sqlTimestamp.getHours(), s.getSqlTimestamp().getHours()); Assert.assertEquals(sqlTimestamp.getMinutes(), s.getSqlTimestamp().getMinutes()); Assert.assertEquals(sqlTimestamp.getSeconds(), s.getSqlTimestamp().getSeconds());
@SuppressWarnings("deprecation") private Timestamp withTZ(Timestamp timestamp, Calendar cal) { if (timestamp == null) return null; int year = timestamp.getYear() + 1900; int month = timestamp.getMonth(); int day = timestamp.getDate(); int hour = timestamp.getHours(); int minute = timestamp.getMinutes(); int second = timestamp.getSeconds(); int nanos = timestamp.getNanos(); int millis = nanos / 1000000; nanos = nanos - millis * 1000000; Timestamp r = new Timestamp(getMillis(cal, year, month, day, hour, minute, second, millis)); r.setNanos(nanos + millis * 1000000); return r; }
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
/** * Converts a {@code java.sql.Timestamp} to a {@code LocalDateTime}. * * @param sqlTimestamp the SQL timestamp, not null * @return the local date-time, not null */ @SuppressWarnings("deprecation") public static LocalDateTime toLocalDateTime(Timestamp sqlTimestamp) { return LocalDateTime.of( sqlTimestamp.getYear() + 1900, sqlTimestamp.getMonth() + 1, sqlTimestamp.getDate(), sqlTimestamp.getHours(), sqlTimestamp.getMinutes(), sqlTimestamp.getSeconds(), sqlTimestamp.getNanos()); }
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
@Override public JsonNode encodeToJson() { String text = String.format(ENGLISH, ISO_USEC_FORMAT, dateTime.getYear() + 1900, dateTime.getMonth() + 1, dateTime.getDate(), dateTime.getHours(), dateTime.getMinutes(), dateTime.getSeconds(), dateTime.getNanos() / 1000); return jsonNodeFactory.textNode(text); }
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
format(getMinutes(), 2, sb); sb.append(':'); format(getSeconds(), 2, sb); sb.append('.'); if (nanos == 0) {
/** * Converts a {@code java.sql.Timestamp} to a {@code LocalDateTime}. * * @param sqlTimestamp the SQL timestamp, not null * @return the local date-time, not null */ @SuppressWarnings("deprecation") public static LocalDateTime toLocalDateTime(Timestamp sqlTimestamp) { return LocalDateTime.of( sqlTimestamp.getYear() + 1900, sqlTimestamp.getMonth() + 1, sqlTimestamp.getDate(), sqlTimestamp.getHours(), sqlTimestamp.getMinutes(), sqlTimestamp.getSeconds(), sqlTimestamp.getNanos()); }
/** * Converts a {@code java.sql.Timestamp} to a {@code LocalDateTime}. * * @param sqlTimestamp the SQL timestamp, not null * @return the local date-time, not null */ @SuppressWarnings("deprecation") public static LocalDateTime toLocalDateTime(Timestamp sqlTimestamp) { return LocalDateTime.of( sqlTimestamp.getYear() + 1900, sqlTimestamp.getMonth() + 1, sqlTimestamp.getDate(), sqlTimestamp.getHours(), sqlTimestamp.getMinutes(), sqlTimestamp.getSeconds(), sqlTimestamp.getNanos()); }
result = result * 100 + val.getHours(); result = result * 100 + val.getMinutes(); result = result * 100 + val.getSeconds(); return Int8.allocSet(heap, result);
@Test public void testTimestampFromStringCoercion() { // as run in tests we go from UTC to local time by coercing. String dateAsString = "1996-08-04 01:02:03"; Long canonical = (Long) sqlTimestampCoercibleType.canonical( dateAsString ); Timestamp coerced = (Timestamp) sqlTimestampCoercibleType.coerce( canonical, java.sql.Timestamp.class ); assertEquals( "String parsing got wrong day", 4, coerced.getDate() ); assertEquals( "String parsing got wrong month", 7, coerced.getMonth() ); assertEquals( "String parsing got wrong year", 96, coerced.getYear() ); assertEquals( "String parsing got wrong hour", 1, coerced.getHours() ); assertEquals( "String parsing got wrong minute", 2, coerced.getMinutes()); assertEquals( "String parsing got wrong second", 3, coerced.getSeconds() ); }
@SuppressWarnings("deprecation") protected void assertDates(Dates dates) { assertNull(dates.nullDate); assertDate(BIRTHDAY, dates.iso8601Date); assertDate(BIRTHDAY, dates.formatedDate); assertDate(BIRTHDAY, dates.sqlDate); assertDate(BIRTHDAY, dates.sqlTimestamp); assertEquals(11, dates.sqlTime.getHours()); assertEquals(22, dates.sqlTime.getMinutes()); assertEquals(33, dates.sqlTime.getSeconds()); assertEquals(11, dates.sqlTimestamp.getHours()); assertEquals(22, dates.sqlTimestamp.getMinutes()); assertEquals(33, dates.sqlTimestamp.getSeconds()); } }