Date Between Query In Mysql

Get This Code: ## 1: The following query:

SELECT * FROM users
WHERE (DATE_COLUMN_NAME BETWEEN '2022-01-12 00:00:00' AND '2022-01-
12 00:00:00');

2: Second Following Query:

SELECT *
FROM users
WHERE (DATE_COLUMN_NAME BETWEEN '2022-01-12 00:00:00' AND '2022-01-12 00:00:00')

3: Third Following Query:

Your query should be another have date as....

select * from users between FIRST_DATE and TO_DATE;