java.sql.Timestamp.getTime()方法的使用及代码示例

x33g5p2x  于2022-01-29 转载在 其他  
字(9.0k)|赞(0)|评价(0)|浏览(154)

本文整理了Java中java.sql.Timestamp.getTime()方法的一些代码示例，展示了Timestamp.getTime()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Timestamp.getTime()方法的具体详情如下：
包路径：java.sql.Timestamp
类名称：Timestamp
方法名：getTime

Timestamp.getTime介绍

[英]Returns the time represented by this Timestamp object, as a long value containing the number of milliseconds since the Epoch (January 1 1970, 00:00:00.000 GMT).
[中]返回此时间戳对象表示的时间，作为一个长值，包含自历元（1970年1月1日，00:00:00.000 GMT）以来的毫秒数。

代码示例

代码示例来源：origin: alibaba/nacos

public void setGmtModified(Timestamp gmtModified) {
    if (gmtModified == null) {
      this.gmtModified = null;
    } else {
      this.gmtModified = new Timestamp(gmtModified.getTime());
    }
  }
}

代码示例来源：origin: gocd/gocd

public Date scheduledDate() {
  return new Date(createdTime.getTime());
}

代码示例来源：origin: apache/flink

private static Timestamp copyTimestamp(Object o) {
  if (o == null) {
    return null;
  } else {
    long millis = ((Timestamp) o).getTime();
    int nanos = ((Timestamp) o).getNanos();
    Timestamp copy = new Timestamp(millis);
    copy.setNanos(nanos);
    return copy;
  }
}

代码示例来源：origin: elasticjob/elastic-job-lite

/**
 * 获取最近一条运行中的任务统计数据.
 * 
 * @return 运行中的任务统计数据对象
 */
public Optional<TaskRunningStatistics> findLatestTaskRunningStatistics() {
  TaskRunningStatistics result = null;
  String sql = String.format("SELECT id, running_count, statistics_time, creation_time FROM %s order by id DESC LIMIT 1", 
      TABLE_TASK_RUNNING_STATISTICS);
  try (
      Connection conn = dataSource.getConnection();
      PreparedStatement preparedStatement = conn.prepareStatement(sql);
      ResultSet resultSet = preparedStatement.executeQuery()
      ) {
    while (resultSet.next()) {
      result = new TaskRunningStatistics(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 taskRunningStatistics from DB error:", ex);
  }
  return Optional.fromNullable(result);
}

代码示例来源：origin: SonarSource/sonarqube

@CheckForNull
public static Date getDate(ResultSet rs, int columnIndex) throws SQLException {
 Timestamp t = rs.getTimestamp(columnIndex);
 return rs.wasNull() ? null : new Date(t.getTime());
}

代码示例来源：origin: SonarSource/sonarqube

int colCount = metaData.getColumnCount();
List<Map<String, Object>> rows = newArrayList();
while (resultSet.next()) {
 Map<String, Object> columns = newHashMap();
 for (int i = 1; i <= colCount; i++) {
   value = new Date(((Timestamp) value).getTime());

代码示例来源：origin: hibernate/hibernate-orm

@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() );
    }
  }
}

代码示例来源：origin: stackoverflow.com

Timestamp stamp = new Timestamp(System.currentTimeMillis());
Date date = new Date(stamp.getTime());
System.out.println(date);

代码示例来源：origin: com.thoughtworks.xstream/xstream

public String toString(Object obj) {
  final Timestamp timestamp = (Timestamp)obj;
  String str = super.toString(new Date((timestamp.getTime() / 1000) * 1000));
  final String nanos = String.valueOf(timestamp.getNanos());
  final int idxFraction = str.lastIndexOf('.');
  str = str.substring(0, idxFraction + 1)
      + PADDING.substring(nanos.length())
      + nanos
      + str.substring(idxFraction + 4);
  return str;
}

代码示例来源：origin: apache/activemq

protected long determineTimeDifference(Connection connection) throws SQLException {
  PreparedStatement statement = connection.prepareStatement(getStatements().getCurrentDateTime());
  ResultSet resultSet = statement.executeQuery();
  long result = 0l;
  if (resultSet.next()) {
    Timestamp timestamp = resultSet.getTimestamp(1);
    long diff = System.currentTimeMillis() - timestamp.getTime();
    if (Math.abs(diff) > maxAllowableDiffFromDBTime) {
      // off by more than maxAllowableDiffFromDBTime so lets adjust
      result = (-diff);
    }
    LOG.info(getLeaseHolderId() + " diff adjust from db: " + result + ", db time: " + timestamp);
  }
  return result;
}

代码示例来源：origin: apache/ignite

/**
 * @throws Exception If failed.
 */
@Test
public void testTimestamp() throws Exception {
  ResultSet rs = stmt.executeQuery(SQL);
  int cnt = 0;
  while (rs.next()) {
    if (cnt == 0) {
      assert rs.getTimestamp("tsVal").getTime() == 1;
      assert rs.getDate(14).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getTime(14).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getTimestamp(14).equals(new Timestamp(1));
      assert rs.getObject(14, Date.class).equals(new Date(new Timestamp(1).getTime()));
      assert rs.getObject(14, Time.class).equals(new Time(new Timestamp(1).getTime()));
      assert rs.getObject(14, Timestamp.class).equals(new Timestamp(1));
    }
    cnt++;
  }
  assert cnt == 1;
}

代码示例来源：origin: blynkkk/blynk-server

private static long getTs(ResultSet rs, String fieldName) throws SQLException {
  Timestamp t = rs.getTimestamp(fieldName, UTC_CALENDAR);
  return t == null ? 0 : t.getTime();
}

代码示例来源：origin: apache/flink

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

代码示例来源：origin: hibernate/hibernate-orm

.prepareStatement( timestampSelectString, false );
ResultSet rs = session.getJdbcCoordinator().getResultSetReturn().extract( ps );
rs.next();
Timestamp ts = rs.getTimestamp( 1 );
if ( LOG.isTraceEnabled() ) {
  LOG.tracev(
      "Current timestamp retrieved from db : {0} (nanos={1}, time={2})",
      ts,
      ts.getNanos(),
      ts.getTime()
  );

代码示例来源：origin: prestodb/presto

@Test
public void testBuildSqlWithTimestamp()
    throws SQLException
{
  TupleDomain<ColumnHandle> tupleDomain = TupleDomain.withColumnDomains(ImmutableMap.of(
      columns.get(6), Domain.create(SortedRangeSet.copyOf(TIMESTAMP,
          ImmutableList.of(
              Range.equal(TIMESTAMP, toTimestamp(2016, 6, 3, 0, 23, 37).getTime()),
              Range.equal(TIMESTAMP, toTimestamp(2016, 10, 19, 16, 23, 37).getTime()),
              Range.range(TIMESTAMP, toTimestamp(2016, 6, 7, 8, 23, 37).getTime(), false, toTimestamp(2016, 6, 9, 12, 23, 37).getTime(), true))),
          false)));
  Connection connection = database.getConnection();
  try (PreparedStatement preparedStatement = new QueryBuilder("\"").buildSql(jdbcClient, connection, "", "", "test_table", columns, tupleDomain, Optional.empty());
      ResultSet resultSet = preparedStatement.executeQuery()) {
    ImmutableSet.Builder<Timestamp> builder = ImmutableSet.builder();
    while (resultSet.next()) {
      builder.add((Timestamp) resultSet.getObject("col_6"));
    }
    assertEquals(builder.build(), ImmutableSet.of(
        toTimestamp(2016, 6, 3, 0, 23, 37),
        toTimestamp(2016, 6, 8, 10, 23, 37),
        toTimestamp(2016, 6, 9, 12, 23, 37),
        toTimestamp(2016, 10, 19, 16, 23, 37)));
    assertContains(preparedStatement.toString(), "\"col_6\" > ?");
    assertContains(preparedStatement.toString(), "\"col_6\" <= ?");
    assertContains(preparedStatement.toString(), "\"col_6\" IN (?,?)");
  }
}

代码示例来源：origin: elasticjob/elastic-job-lite

/**
 * 获取最近一条运行中的任务统计数据.
 * 
 * @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);
}

代码示例来源：origin: nutzam/nutz

@Override
public Date cast(Timestamp src, Class<?> toType, String... args)
    throws FailToCastObjectException {
  return new java.util.Date(src.getTime());
}

代码示例来源：origin: nutzam/nutz

public Object get(ResultSet rs, String colName) throws SQLException {
  Timestamp ts = rs.getTimestamp(colName);
  return null == ts ? null : new java.util.Date(ts.getTime());
}

代码示例来源：origin: apache/geode

@Test
public void readOfObjectFieldWithTimestampColumnWritesDate() throws Exception {
 FieldType fieldType = FieldType.OBJECT;
 ResultSetMetaData metaData = mock(ResultSetMetaData.class);
 when(resultSet.getMetaData()).thenReturn(metaData);
 when(metaData.getColumnCount()).thenReturn(1);
 when(metaData.getColumnName(1)).thenReturn(COLUMN_NAME_1);
 java.sql.Timestamp sqlTimestamp = java.sql.Timestamp.valueOf("1979-09-11 22:33:44.567");
 Date expectedValue = new Date(sqlTimestamp.getTime());
 when(resultSet.getObject(1)).thenReturn(sqlTimestamp);
 when(resultSet.next()).thenReturn(true).thenReturn(false);
 PdxInstanceFactory factory = setupPdxInstanceFactory(fieldType);
 when(regionMapping.getFieldNameForColumn(eq(COLUMN_NAME_1), any()))
   .thenReturn(PDX_FIELD_NAME_1);
 createPdxInstance();
 verifyPdxFactoryWrite(factory, fieldType, expectedValue);
 verify(factory).create();
}

代码示例来源：origin: stackoverflow.com

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;

public class DateTest {

  public static void main(String[] args) {
    Timestamp timestamp = new Timestamp(System.currentTimeMillis());
    Date date = new Date(timestamp.getTime());

    // S is the millisecond
    SimpleDateFormat simpleDateFormat = new SimpleDateFormat("MM/dd/yyyy' 'HH:mm:ss:S");

    System.out.println(simpleDateFormat.format(timestamp));
    System.out.println(simpleDateFormat.format(date));
  }
}

内容来源于网络，如有侵权，请联系作者删除！

timestamp

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com