title: timestamp to date in java and get the count value
body: <p>hi i have to convert timestamp to date after check the query and return the count value.
  my database have date(1344399208,1344399269),status(Q,Q).
  This is my code:</p>
  
  <pre><code>public class GetCurrentDateTime {
   public int data(){
  int count=0;
  java.sql.Timestamp timeStamp =new Timestamp(System.currentTimeMillis());
  
            java.sql.Date      date      = new java.sql.Date(timeStamp.getTime()); 
             System.out.println(date);
  //count++;
  
  
  try{
      Class.forName("com.mysql.jdbc.Driver");
      Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/xcart-432pro","root","");
  
      PreparedStatement statement =  con.prepareStatement("select * from xcart_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;
         }
  
          }
  </code></pre>
  
  <p>Here the date is saved in timestamp format.but i like to convert date(yyyy-mm-dd) format.its done successfully.ya i got the output is 2012-08-08.but i have to check the query <strong>today date+status=Q</strong> .so how is that date is save in variable and call that variable in query.so how is wrote query for above condition.after check the condition and display the returns count value on my tomcat console.How is to do.please help me </p>