How to retrieve the row between two dates in PostgreSQL? In the above example, end_date column is NULLABLE. I want to retrieve the row using the date which falls in-between START_DATE & END_DATE. Endate NULL is considered it as infinite. I am clueless on how to pass single date input to two columns and handle NULL Answer If you are