How to use

Timestamp

in

java.sql

  @Override
  public java.sql.Timestamp convert(String s) throws ParseException {
    if (timeStampWithoutSecPatternLen == s.length()) {
      s = s + ":00";
    }
    if (s.length() > dateLen) {
      return java.sql.Timestamp.valueOf(s);
    }
    else {
      return new java.sql.Timestamp(new SimpleDateFormat(datePattern).parse(s).getTime());
    }
  }
}

/**
 * 获取最近一条运行中的任务统计数据.
 * 
 * @return 运行中的任务统计数据对象
 */
public Optional<JobRunningStatistics> findLatestJobRunningStatistics() {
  JobRunningStatistics result = null;
  String sql = String.format("SELECT id, running_count, statistics_time, creation_time FROM %s order by id DESC LIMIT 1", 
      TABLE_JOB_RUNNING_STATISTICS);
  try (
      Connection conn = dataSource.getConnection();
      PreparedStatement preparedStatement = conn.prepareStatement(sql);
      ResultSet resultSet = preparedStatement.executeQuery()
      ) {
    while (resultSet.next()) {
      result = new JobRunningStatistics(resultSet.getLong(1), resultSet.getInt(2), 
          new Date(resultSet.getTimestamp(3).getTime()), new Date(resultSet.getTimestamp(4).getTime()));
    }
  } catch (final SQLException ex) {
    // TODO 记录失败直接输出日志,未来可考虑配置化
    log.error("Fetch latest jobRunningStatistics from DB error:", ex);
  }
  return Optional.fromNullable(result);
}

@Override
public String objectToSQLString(Date value, Dialect dialect) throws Exception {
  final Timestamp ts = Timestamp.class.isInstance( value )
      ? ( Timestamp ) value
      : new Timestamp( value.getTime() );
  // TODO : use JDBC date literal escape syntax? -> {d 'date-string'} in yyyy-mm-dd hh:mm:ss[.f...] format
  return StringType.INSTANCE.objectToSQLString( ts.toString(), dialect );
}

@Override
public Timestamp copy(Timestamp from) {
  if (from == null) {
    return null;
  }
  final Timestamp t = new Timestamp(from.getTime());
  t.setNanos(from.getNanos());
  return t;
}

@Override
public Timestamp copy(Timestamp from, Timestamp reuse) {
  if (from == null) {
    return null;
  }
  reuse.setTime(from.getTime());
  reuse.setNanos(from.getNanos());
  return reuse;
}

private static String formatTimestamp(long t, long start) {
  String x = new Timestamp(t).toString();
  String s = x.substring(0, 19);
  s += " (+" + ((t - start) / 1000) + " s)";
  return s;
}

 java.util.Date utilDate = new java.util.Date();
Calendar cal = Calendar.getInstance();
cal.setTime(utilDate);
cal.set(Calendar.MILLISECOND, 0);
System.out.println(new java.sql.Timestamp(utilDate.getTime()));
System.out.println(new java.sql.Timestamp(cal.getTimeInMillis()));

@SuppressWarnings({ "unchecked" })
public <X> X unwrap(Calendar value, Class<X> type, WrapperOptions options) {
  if ( value == null ) {
    return null;
  }
  if ( Calendar.class.isAssignableFrom( type ) ) {
    return (X) value;
  }
  if ( java.sql.Date.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Date( value.getTimeInMillis() );
  }
  if ( java.sql.Time.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Time( value.getTimeInMillis() );
  }
  if ( java.sql.Timestamp.class.isAssignableFrom( type ) ) {
    return (X) new java.sql.Timestamp( value.getTimeInMillis() );
  }
  if ( java.util.Date.class.isAssignableFrom( type ) ) {
    return (X) new  java.util.Date( value.getTimeInMillis() );
  }
  throw unknownUnwrap( type );
}

@Deprecated
public static Timestamp plus(Timestamp self, int days) {
  Calendar calendar = Calendar.getInstance();
  calendar.setTime(self);
  calendar.add(Calendar.DATE, days);
  Timestamp ts = new Timestamp(calendar.getTime().getTime());
  ts.setNanos(self.getNanos());
  return ts;
}

  @Override
  public Date deepCopyNotNull(Date value) {
    if ( value instanceof Timestamp ) {
      Timestamp orig = (Timestamp) value;
      Timestamp ts = new Timestamp( orig.getTime() );
      ts.setNanos( orig.getNanos() );
      return ts;
    }
    else {
      return new Date( value.getTime() );
    }
  }
}

@Test
public void testTimestamp() {
  Date d = new Date(0);
  Timestamp ts = new Timestamp(0);
  assertThat(jdkTypeToJson(ts), containsString(new SimpleDateFormat("yyyy-MM-dd").format(d)));
}

private Timestamp getTimestamp(final MySQLPacketPayload payload) {
  Calendar calendar = Calendar.getInstance();
  calendar.set(0, Calendar.JANUARY, 0, payload.readInt1(), payload.readInt1(), payload.readInt1());
  Timestamp result = new Timestamp(calendar.getTimeInMillis());
  result.setNanos(0);
  return result;
}

ps.setString(paramIndex, inValue.toString());
ps.setNString(paramIndex, inValue.toString());
    ps.setNClob(paramIndex, new StringReader(strVal), strVal.length());
    ps.setDate(paramIndex, new java.sql.Date(((java.util.Date) inValue).getTime()));
  ps.setDate(paramIndex, new java.sql.Date(cal.getTime().getTime()), cal);
    ps.setTime(paramIndex, new java.sql.Time(((java.util.Date) inValue).getTime()));
  ps.setTime(paramIndex, new java.sql.Time(cal.getTime().getTime()), cal);
    ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime()));
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(cal.getTime().getTime()), cal);
  "Oracle".equals(ps.getConnection().getMetaData().getDatabaseProductName()))) {
if (isStringValue(inValue.getClass())) {
  ps.setString(paramIndex, inValue.toString());
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(((java.util.Date) inValue).getTime()));
  ps.setTimestamp(paramIndex, new java.sql.Timestamp(cal.getTime().getTime()), cal);

protected void readFieldValue(Object object, FieldInfo field, ResultSet rs, int paramIndex) throws SQLException {
  Class<?> fieldType = field.getFieldType();
  Object fieldValue = null;
  if (fieldType.equals(int.class) || fieldType.equals(Integer.class)) {
    fieldValue = rs.getInt(paramIndex);
  } else if (fieldType.equals(long.class) || fieldType.equals(Long.class)) {
    fieldValue = rs.getLong(paramIndex);
  } else if (fieldType.equals(String.class)) {
    fieldValue = rs.getString(paramIndex);
  } else if (fieldType.equals(Date.class)) {
    Timestamp timestamp = rs.getTimestamp(paramIndex);
    if (timestamp != null) {
      fieldValue = new Date(timestamp.getTime());
    }
  } else {
    throw new UnsupportedOperationException();
  }
  try {
    field.getField().set(object, fieldValue);
  } catch (IllegalArgumentException e) {
    throw new DruidRuntimeException("set field error" + field.getField(), e);
  } catch (IllegalAccessException e) {
    throw new DruidRuntimeException("set field error" + field.getField(), e);
  }
}

@Test
public void testSetParameterValueWithDateAndUnknownType() throws SQLException {
  java.util.Date date = new java.util.Date(1000);
  StatementCreatorUtils.setParameterValue(preparedStatement, 1, SqlTypeValue.TYPE_UNKNOWN, null, date);
  verify(preparedStatement).setTimestamp(1, new java.sql.Timestamp(1000));
}

private byte[] encodeTime(Timestamp timestamp) {
 ByteBuffer encoded;
 long time = timestamp.getTime();
 try {
  String formatted = dateFormat.format(new Date(time));
  encoded = Text.encode(formatted);
 } catch (CharacterCodingException e) {
  throw new RuntimeException(e);
 }
 return Arrays.copyOf(encoded.array(), encoded.limit());
}

private boolean updateJobExecutionEventWhenSuccess(final JobExecutionEvent jobExecutionEvent) {
  boolean result = false;
  String sql = "UPDATE `" + TABLE_JOB_EXECUTION_LOG + "` SET `is_success` = ?, `complete_time` = ? WHERE id = ?";
  try (
      Connection conn = dataSource.getConnection();
      PreparedStatement preparedStatement = conn.prepareStatement(sql)) {
    preparedStatement.setBoolean(1, jobExecutionEvent.isSuccess());
    preparedStatement.setTimestamp(2, new Timestamp(jobExecutionEvent.getCompleteTime().getTime()));
    preparedStatement.setString(3, jobExecutionEvent.getId());
    if (0 == preparedStatement.executeUpdate()) {
      return insertJobExecutionEventWhenSuccess(jobExecutionEvent);
    }
    result = true;
  } catch (final SQLException ex) {
    // TODO 记录失败直接输出日志,未来可考虑配置化
    log.error(ex.getMessage());
  }
  return result;
}

private Timestamp convertToTimestamp(Object object) {
  final long millis;
  if (object instanceof Long) {
    millis = (Long) object;
  } else {
    // use 'provided' Joda time
    final DateTime value = (DateTime) object;
    millis = value.toDate().getTime();
  }
  return new Timestamp(millis - LOCAL_TZ.getOffset(millis));
}

public Person createModesty() {
  Address benhome = new Address("NN Island", "Blue Cave", "ta", new Zipcode("82742"));
  Address benwork = new Address("44 Planetary St.", "Neptune", "Milkiway", new Zipcode("12345"));
  Calendar benCal = Calendar.getInstance();
  benCal.set(1986, Calendar.AUGUST, 8, 8, 11);
  Person ben = new Person("Modesty", "Blase", benCal.getTime(), benhome, benwork);
  benCal = Calendar.getInstance();
  benCal.set(1995, Calendar.MAY, 21, 8, 11);
  ben.setFirstBaseBallGame(new Timestamp(benCal.getTime().getTime()));
  ben.getHobbies().add("sneak");
  ben.getHobbies().add("kill");
  ben.getHobbies().add("fight");
  return ben;
}

 DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
Date date = dateFormat.parse("23/09/2007");
long time = date.getTime();
new Timestamp(time);