How to convert java.util.Date to java.sql.Date?

java sql datetime date
David Ackerman picture David Ackerman · Feb 9, 2009 · Viewed 640.2k times · Source

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date.

I was surprised to find that it couldn't do the conversion implicitly or explicitly - but I don't even know how I would do this, as the Java API is still fairly new to me.

Answer

David Ackerman picture David Ackerman · Feb 9, 2009

Nevermind....

public class MainClass {

  public static void main(String[] args) {
    java.util.Date utilDate = new java.util.Date();
    java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
    System.out.println("utilDate:" + utilDate);
    System.out.println("sqlDate:" + sqlDate);

  }

}

explains it. The link is http://www.java2s.com/Tutorial/Java/0040__Data-Type/ConvertfromajavautilDateObjecttoajavasqlDateObject.htm

Related questions

java.util.Date vs java.sql.Date

java.util.Date vs java.sql.Date: when to use which and why?

Read More
Converting java date to Sql timestamp

I am trying to insert java.util.Date after converting it to java.sql.Timestamp and I am using the following snippet: java.util.Date utilDate = new java.util.Date(); java.sql.Timestamp sq = new java.sql.Timestamp(utilDate.getTime()); …

Read More
A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)

So far, I have not found a clear answer to this. I'd like to know what the equivalent is for a SQL type DATETIME and the java type, using a PreparedStatement. I have found: http://www.java2s.com/Code/…

Read More