Java comparing dates

Question

I have a database of suppliers, they rent car. Most people rent for a range of 2-3 days. on the database i have the rent start date/time stored in as datetime format. the rent end date is also in date time format.

suppose someone wants to rent the same car, if the requested range of date falls in one of the ranges of date the car is already rented out - how can i check the availability? i am using beans, servlets and jstl on the jsp pages.

i guess it should be a comparator?

Wyzard · Accepted Answer · 2012-03-30 00:32:49Z

4

If you're doing the comparisons in Java, the java.util.Date class already implements Comparable so you can just use its compareTo() method. But you can probably also do the comparisons in your database, using the < and > operators in SQL.

There's also the SQL OVERLAPS function, which lets you compare two date ranges to see if they overlap each other. That's probably simpler and more efficient, if your database supports it.

For example, supposing your table is called "reservations", you could do:

SELECT id FROM reservations
WHERE (DATE '2012-03-29', DATE '2010-04-01') OVERLAPS (start_date, stop_date)
  AND car_id = 12345;

And if that returns any rows, it means there's already a reservation for car 12345 that conflicts with that date range.

edited Mar 30, 2012 at 0:32

answered Mar 30, 2012 at 0:19

Wyzard

34.8k3 gold badges74 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Parvesh Over a year ago

could you provide me a link to any good resource on the compareto() method

Wyzard Over a year ago

How about Oracle's documentation for the Date class? You should have that site bookmarked already if you're doing Java development.

Collectives™ on Stack Overflow

Java comparing dates

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related