How to get data between two date range in PostgreSQL?

How to get data between two date range in PostgreSQL?

I m querying data between two date range in PostgreSQL SQL but it does not give me expected result.

I m querying data between two date range in PostgreSQL SQL but it does not give me expected result.

select
    pi_serial,
    amount_in_local_currency,
    status,
    proforma_invoice_date
from proforma_invoice
where created_by = 25
    and proforma_invoice_date BETWEEN '03/01/2018' and '09/03/2018'
order by proforma_invoice_date

Now look at the query and column proforma_invoice_date. In this query i am searching data between 03/01/2018 and 09/03/2018. the date format is (DD/MM/YYYY) and it's character varying. The result i have got in this picture. it just give me the result according by the only day but not the whole date format. i have tried so many things date conversion, character varying to date. but i didn't get any expected result

postgresql

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Compare PgBouncer vs. Pgpool-II to see which PostgreSQL connection pooler offers the best features, and analyze throughput (TPS) in a performance benchmark.

PostgreSQL Tutorial for Beginners in one video | PostgreSQL Tutorial | Learn PostgreSQL

In this video provides Introduction to PostgreSQL. The PostgreSQL installers created by EnterpriseDB are designed to make it quick and simple to install PostgreSQL on your computer. The installer provides:

PostgreSQL Tutorial - Learn PostgreSQL Database from Scratch

PostgreSQL Tutorial - Learn PostgreSQL Database from Scratch. Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems. What is a Database? What is SQL And Relational Database? What is PostreSQL AKA Postrgres? PostgreSQL Installation. How to Create Database.

Difference between postgresql.conf and postgresql.auto.conf

In this video, you'll see the difference between postgresql.conf and postgresql.auto.conf

8 Reasons To Learn PostgreSQL | Benefits of PostgreSQL Training

Learning PostgreSQL which is in demand now more than ever will certainly help you climb up the ladder of success. Explore the benefits of attending the PostgreSQL Training program.Now it plays a key role in many integrated data centers across the globe.