convert timestamp to date

[Anthony Smith]

How do I convert a java.sql.Timestamp to java.sql.Date? I thought I could just cast the (java.sql.Date)timestamp_var but that does nto work.

[Wayne L Johnson]

Both of the classes (java.sql.Date and java.sql.Timestamp) subclass java.util.Date, so as "siblings" you can not cast instances of one to instances of another. However you'll notice that both of them inherit [or override] the "getTime()" method which returns a value of type "long". Both of them also have a constructor that takes a value of type "long".
So you can do the following:

   java.sql.Timestamp timeStamp = ... (however you get it).
   java.sql.Date      date      = new java.sql.Date(timeStamp.getTime());

[Dirk Schreckmann]

Moving this to the JDBC forum...
[ October 03, 2003: Message edited by: Dirk Schreckmann ]