Untitled

 recon_start_date                      | 2023-05-03 18:00:00.000000+0530
 recon_end_date                        | 2023-05-03 18:59:59.000000+0530
 event_type                            | updatePartyRole
 no_of_failed_events                   | 0
 no_of_failed_events_pubished_to_kafka | 0
 no_of_passed_events                   | 642
 no_of_passed_events_via_recon         | 0
 total_no_of_events                    | 642

above is my cassandra tables i want to query using date like select * from table_name recon_start_date>=2023-05-03 and recon_end_date<=2023-05-03;
how to do it