This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes date comparison Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "date comparison" Watch "date comparison" New topic
Author

date comparison

prakash muthu
Ranch Hand

Joined: Sep 06, 2000
Posts: 75
Hi,
I stuck with date comparison. The user will enter a date in browser (HTML file). I suppose to check with a date available in Access database. The problem is, date is stored with time in access and what ever i typed is in string format.
so if you have any idea about the comparison, let me know
TIA
with regards
Prakash
(praksahem@rediffmail.com)

Prakash.M<BR>Bangalore- India<BR>(prakashem@rediffmail.com)
Peter Tran
Bartender

Joined: Jan 02, 2001
Posts: 783
Prakash,
Take a look at http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-dates.html
I hope the article can give you some ideals.
Good luck,
-Peter
Okay...I took out the period at the end of the URL. Try it now.
[This message has been edited by Peter Tran (edited January 03, 2001).]
Ipsita Naravane
Greenhorn

Joined: Dec 27, 2000
Posts: 29
Peter,
I was not able to go to that link.
Prakash, I think you can convert the date to Timestamp and then compare it with the date in the database.
Shilpa
Peter Tran
Bartender

Joined: Jan 02, 2001
Posts: 783
http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-dates.html
Try the link now. If it still gives you a problem, try making sure you don't have a period at the end of URL.
prakash muthu
Ranch Hand

Joined: Sep 06, 2000
Posts: 75
Hi Peter and Shilpa,
thanks for your mail. I already have the article from Java world. But i couldn't get any points from there. I'll try to convert to timestamp and let you know peoples.
with regards
Prakash
(prakashem@rediffmail.com)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: date comparison
 
Similar Threads
Calendar / Date arithmetic
Relative query efficiencies
Compare Date.
Using an int to hold a four digit date
JBoss started date ???