I want to calculate if a date retrieved from a database (in the normal Date form) is before or after the current one. Using "boolean equals(Date d)" won't work since the date is retrieved from the database as a string. How do I take this string and convert it to a date, d, so that I can use the above method? Thanks in advance, James
The simplest method, assuming that the date is stored as type "date" in your database is to retrieve it in its java-equivalent form. That is: java.sql.date xdate = (java.sql.Date) rs.getObject("xdate"); Please note that class java.sql.Date is NOT java.util.Date! If you can only get the date as a string, you have to either parse it out yourself and use the month/day/year form of the date constructor or use the Calendar class feature to do locale-sensitive construction.
Customer surveys are for companies who didn't pay proper attention to begin with.
Joined: Jul 06, 2001
Which database are you using? I can help you if it's Oracle. SAF
Joined: Jul 09, 2001
Thanks very much. Parsing it worked fine. It was db2 by the way. Thanks, James
Joined: Jul 10, 2001
I had a similar problem, and my solution was to create a DateUtil class specific to my DB - MSAccess. It implements Comparable, and returns the short date form. Yours would be similar. Hope that helps.
Joined: Feb 02, 2001
Try to use java.text.DateFormat.parse(String text) which returns Date object. -venu