Sql时间戳到Java日期？ [英] Sql timestamp to Java date?

问题描述

我有一个数据库将具有标准sql格式的UMT时间戳。我如何提取数据并设置一个java日期对象？

据我所知，mysql是 yyyy-mm-dd hh： mm：ss 对于java来说，日期/时间的东西一直都没有我。

如果有人知道一个很好的图书馆，我是

解决方案

为什么不直接读作 Date

  Date date = resultSet.getTimestamp（date_field）; 
 
 Timestamp timestamp = resultSet.getTimestamp（date_time_field）; 
  

查看

• ResultSet.getTimeStamp（）

I have a database which is going to have UMT timestamps in standard sql format. How can I pull that data and set a java date object with it?

As far as I know mysql is yyyy-mm-dd hh:mm:ss As for java, the date / time stuff has always eluded me.

If anyone knows of a good library for this I am open to suggestions.

解决方案

Why don't directly read it as Date

Date date = resultSet.getTimestamp("date_field");

Timestamp timestamp = resultSet.getTimestamp("date_time_field");

See

• ResultSet.getTimeStamp()

这篇关于Sql时间戳到Java日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！