Data Loss in Time Range Query - Unable to Retrieve Newly Created Data for a Specific Date

[Joe-rise]

I am experiencing an issue with the time range query functionality in our application. When performing a query to retrieve data created after a certain timestamp, I am unable to fetch any newly created data for the current day.

Steps to Reproduce:

1. Create a new data entry with a timestamp set to today.
2. Use the time range query to retrieve data created after a specific date.
3. Execute the following request:

{
    "query": {
        "bool": {
            "must": [
                {
                    "range": {
                        "create_time": {
                            "gte":"2023-08-16 00:30:12",
                            "format":"2006-01-02 15:04:05"
                        }
                    }
                }
            ]
        }
    },
    "from": 0,
    "size": 10
}

4. Observe the results.

Expected Behavior:
The query should return all data entries created on the current day, as the timestamp constraint is set to include today's date.

Actual Behavior:
The query fails to retrieve any data entries created on the current day. It only returns data from previous days, excluding the newly created data for today.

Additional Information:

• The issue can be reproduced consistently.
• The provided query structure and constraints have been verified.
• Other types of queries (e.g., by user, by category) do not exhibit this issue.
• The application version is 0.4.7, built on commit hash 4885180 on branch 0, with a build date of 2023-06-16T04:41:42Z.

Please let me know if any further information or clarification is required to investigate and resolve this issue.

[hengfeiyang]

With start and end time, i got two records.

Only with start time, I only got one record.

Maybe this is a bug.

Please notice: it can't get the data of the current day.