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

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

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

Timestamp.valueOf介绍

[英]Creates a Timestamp object with a time value equal to the time specified by a supplied String holding the time in JDBC timestamp escape format, which is "yyyy-MM-dd HH:mm:ss.nnnnnnnnn"
[中]创建时间戳对象，其时间值等于以JDBC时间戳转义格式保存时间的提供字符串指定的时间，该格式为“yyyy-MM-dd-HH:MM:ss.nnnnn”

代码示例

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

@Override
public java.sql.Timestamp convertToPersisted(LocalDateTime value) {
  if (value == null) {
    return null;
  }
  return java.sql.Timestamp.valueOf(value);
}

代码示例来源：origin: TommyLemon/APIJSON

/**获取时间戳 TODO 判空？ 还是要报错？
 * @param time
 * @return
 */
public static Timestamp getTimeStamp(String time) {
  return Timestamp.valueOf(time);
}
/**获取时间毫秒值 TODO 判空？ 还是要报错？

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

@Override
  public void apply(final int position,
           final PreparedStatement statement,
           final StatementContext ctx) throws SQLException {
    if (value != null) {
      statement.setTimestamp(position, Timestamp.valueOf(value));
    } else {
      statement.setNull(position, Types.TIMESTAMP);
    }
  }
}

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

@Override
  public void apply(int position, PreparedStatement statement, StatementContext ctx) throws SQLException {
    if (value != null) {
      statement.setTimestamp(position, Timestamp.valueOf(value.atStartOfDay()));
    } else {
      statement.setNull(position, Types.TIMESTAMP);
    }
  }
}

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

@Override
public Timestamp[] getValidTestResults() {
  return new Timestamp[] {
    Timestamp.valueOf("1970-01-01 00:00:00.000"), Timestamp.valueOf("1990-10-14 02:42:25"), Timestamp.valueOf("1990-10-14 02:42:25.123"),
    Timestamp.valueOf("1990-10-14 02:42:25.123000001"), Timestamp.valueOf("1990-10-14 02:42:25.123000002"),
    Timestamp.valueOf("2013-08-12 14:15:59.478"), Timestamp.valueOf("2013-08-12 14:15:59.47"),
    Timestamp.valueOf("0000-01-01 00:00:00.000")
  };
}

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

private Timestamp getBeforeStamp(Timestamp date, int step) {
  Calendar cal = Calendar.getInstance();
  /**
   *  date 换成已经已知的Date对象
   */
  cal.setTime(date);
  /**
   *  before 6 hour
   */
  cal.add(Calendar.HOUR_OF_DAY, -step);
  SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  return Timestamp.valueOf(format.format(cal.getTime()));
}

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

@Override
  protected Timestamp[] getSortedTestData() {
    return new Timestamp[] {
      Timestamp.valueOf("1970-01-01 00:00:00.000"),
      Timestamp.valueOf("1990-10-14 02:42:25.123"),
      Timestamp.valueOf("1990-10-14 02:42:25.123000001"),
      Timestamp.valueOf("1990-10-14 02:42:25.123000002"),
      Timestamp.valueOf("2013-08-12 14:15:59.478"),
      Timestamp.valueOf("2013-08-12 14:15:59.479"),
      Timestamp.valueOf("2040-05-12 18:00:45.999")
    };
  }
}

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

@Override
  protected Timestamp[] getTestData() {
    return new Timestamp[] {
      new Timestamp(0L),
      Timestamp.valueOf("1970-01-01 00:00:00.000"),
      Timestamp.valueOf("1990-10-14 02:42:25.123"),
      Timestamp.valueOf("1990-10-14 02:42:25.123000001"),
      Timestamp.valueOf("1990-10-14 02:42:25.123000002"),
      Timestamp.valueOf("2013-08-12 14:15:59.478"),
      Timestamp.valueOf("2013-08-12 14:15:59.479"),
      Timestamp.valueOf("2040-05-12 18:00:45.999")
    };
  }
}

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

@Override
public Timestamp convertToDatabaseColumn(LocalDateTime localDateTime) {
  return localDateTime == null ? null : Timestamp.valueOf( localDateTime );
}

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

ps.setTimestamp(2, new java.sql.Timestamp(System.currentTimeMillis()));

// Since Java 8
ps.setTimestamp(2, java.sql.Timestamp.from(java.time.Instant.now()));
ps.setTimestamp(2, java.sql.Timestamp.valueOf(java.time.LocalDateTime.now()));

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

private static Timestamp toTimestamp(int year, int month, int day, int hour, int minute, int second)
{
  return Timestamp.valueOf(LocalDateTime.of(year, month, day, hour, minute, second));
}

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

@Test(groups = FUNCTIONS)
public void testToTimestamp()
{
  assertThat(onPresto().executeQuery("SELECT to_timestamp('1988/04/08;02:03:04','yyyy/mm/dd;hh24:mi:ss')"))
      .contains(row(Timestamp.valueOf(LocalDateTime.of(1988, 4, 8, 2, 3, 4))));
}

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

private static void assertTimestampCorrect(String timestampString)
  {
    Timestamp timestamp = Timestamp.valueOf(timestampString);
    Binary timestampBytes = NanoTimeUtils.getNanoTime(timestamp, false).toBinary();
    long decodedTimestampMillis = getTimestampMillis(timestampBytes);
    assertEquals(decodedTimestampMillis, timestamp.getTime());
  }
}

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

@Test
public void testBulkUpdate() {
  doInJPA( this::entityManagerFactory, entityManager -> {
    int updateCount = entityManager.createQuery(
      "UPDATE Person u " +
      "SET u.employedOn = :date " +
      "WHERE u.id IN :userIds"
    )
    .setParameter( "date", Timestamp.valueOf( "2018-06-03 00:00:00" ) )
    .setParameter( "userIds", Arrays.asList(1L, 2L, 3L ) )
    .executeUpdate();
    assertEquals(3, updateCount);
  });
}

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

@Test
public void testConvertTimestamp()
    throws SQLException
{
  LocalDateTime dateTime = LocalDateTime.of(2001, 5, 6, 12, 34, 56);
  Date sqlDate = Date.valueOf(dateTime.toLocalDate());
  Time sqlTime = Time.valueOf(dateTime.toLocalTime());
  Timestamp sqlTimestamp = Timestamp.valueOf(dateTime);
  java.util.Date javaDate = java.util.Date.from(dateTime.atZone(ZoneId.systemDefault()).toInstant());
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setTimestamp(i, sqlTimestamp));
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setObject(i, sqlTimestamp));
  assertParameter(new Timestamp(sqlDate.getTime()), Types.TIMESTAMP, (ps, i) -> ps.setObject(i, sqlDate, Types.TIMESTAMP));
  assertParameter(new Timestamp(sqlTime.getTime()), Types.TIMESTAMP, (ps, i) -> ps.setObject(i, sqlTime, Types.TIMESTAMP));
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setObject(i, sqlTimestamp, Types.TIMESTAMP));
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setObject(i, javaDate, Types.TIMESTAMP));
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setObject(i, dateTime, Types.TIMESTAMP));
  assertParameter(sqlTimestamp, Types.TIMESTAMP, (ps, i) -> ps.setObject(i, "2001-05-06 12:34:56", Types.TIMESTAMP));
}

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

/** */
@Test
public void testTimestamp() throws Exception {
  testPutGet(ValueTimestamp.get(Timestamp.valueOf("2017-02-20 10:01:01")),
    ValueTimestamp.get(Timestamp.valueOf("2017-02-20 10:01:01")),
    ValueTimestamp.get(Timestamp.valueOf("2017-02-20 10:01:01")));
}

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

@Test
public void testConvertTime()
    throws SQLException
{
  LocalTime time = LocalTime.of(12, 34, 56);
  Time sqlTime = Time.valueOf(time);
  java.util.Date javaDate = new java.util.Date(sqlTime.getTime());
  LocalDateTime dateTime = LocalDateTime.of(LocalDate.of(2001, 5, 6), time);
  Timestamp sqlTimestamp = Timestamp.valueOf(dateTime);
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setTime(i, sqlTime));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, sqlTime));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, sqlTime, Types.TIME));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, sqlTimestamp, Types.TIME));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, javaDate, Types.TIME));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, dateTime, Types.TIME));
  assertParameter(sqlTime, Types.TIME, (ps, i) -> ps.setObject(i, "12:34:56", Types.TIME));
}

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

@Test
public void testConvertDate()
    throws SQLException
{
  LocalDate date = LocalDate.of(2001, 5, 6);
  Date sqlDate = Date.valueOf(date);
  java.util.Date javaDate = new java.util.Date(sqlDate.getTime());
  LocalDateTime dateTime = LocalDateTime.of(date, LocalTime.of(12, 34, 56));
  Timestamp sqlTimestamp = Timestamp.valueOf(dateTime);
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setDate(i, sqlDate));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlDate));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlDate, Types.DATE));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, sqlTimestamp, Types.DATE));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, javaDate, Types.DATE));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, date, Types.DATE));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, dateTime, Types.DATE));
  assertParameter(sqlDate, Types.DATE, (ps, i) -> ps.setObject(i, "2001-05-06", Types.DATE));
}

代码示例来源：origin: pentaho/pentaho-kettle

@Test
public void getTimestamp_Test() throws Exception {
 ValueMetaTimestamp v = new ValueMetaTimestamp( "TS" );
 RowMetaInterface row = mock( RowMetaInterface.class );
 doReturn( v ).when( row ).searchValueMeta( anyString() );
 doReturn( 0 ).when( row ).indexOfValue( anyString() );
 assertEquals( Timestamp.valueOf( "2018-07-23 12:40:55" ),
  new FieldHelper( row, "TS" ).getTimestamp( new Object[] { Timestamp.valueOf( "2018-07-23 12:40:55" ) } ) );
}

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

@Override
protected void afterEntityManagerFactoryBuilt() {
  super.afterEntityManagerFactoryBuilt();
  doInJPA( this::entityManagerFactory, entityManager -> {
    Event event = new Event();
    event.setId( 1L );
    event.setMessage( "ABC" );
    event.setCreatedOn( Timestamp.valueOf( "9999-12-31 00:00:00" ) );
    entityManager.persist( event );
  } );
}

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

timestamp

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

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