Oracle SQL AND condition for DATE

Question

如何在oracle SQL中查询下表中的AND条件。

我想查询Start_date=某物和End_date=某物的位置

ID   Start_date                       End_date                         STATUS            USER        
21  4/16/2010 11:00:00 PM          4/16/2010 11:59:00 PM               PENDING           TOM
22  4/18/2010 11:00:00 AM          4/18/2010 11:59:00 PM               COMPLETED         JACK
23  4/20/2010 11:00:00 PM          4/20/2010 11:59:00 PM               PENDING           JEFF
24  5/16/2010 11:00:00 PM          5/16/2010 11:59:00 PM               STARTED           MIKE

Answer 1

where start_date = '4/16/2010 11:00:00 PM' and end_date = '4/16/2010 11:59:00 PM'