在Java中将时间戳转换为日期 [英] converting timestamp to date in java

问题描述

这是我的数据库:

在这里，我必须检查查询的当前日期+ status = Q信息并获取计数值.

Here I have to check the query current date+status=Q information and get the count value.

这是我的代码:

public class TodayQ {
    public int data() {
         int count=0;
        Date date = new Date(timestamp);
DateFormat dateFormat = new SimpleDateFormat ("yyyy-MM-dd");
System.out.println( dateFormat.format (date));

        // count++;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/pro", "root", "");

            PreparedStatement statement = con
                    .prepareStatement("select * from orders where status='Q' AND date=CURDATE()");
            ResultSet result = statement.executeQuery();
            while (result.next()) {
                // Do something with the row returned.
                count++; // if the first col is a count.
            }

        }

        catch (Exception exc) {
            System.out.println(exc.getMessage());
        }

        return count;
    }

}

在这里，我必须编辑日期为(yyyy-mm-dd)格式的日期.现在我得到了输出.但是我希望在数据库上使用时间戳.那么如何在Java中将时间戳转换为日期.在我的代码中如何使用该代码?

Here I have to edit the date is (yyyy-mm-dd) format. Now I got the output. But I wish to use timestamp on my database. So how is converted timestamp to date in Java. How is use that code in my code?

推荐答案

您可以使用mysql函数来实现相同的目的.希望以下查询为您提供所需的输出.

You can achieve the same using mysql functions. Hope the following query gives you the desired output.

select * 
from orders
where status='Q' AND 
      date_format(from_unixtime(date),'%Y-%m-%d') = current_date;

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