Querying PostgreSQL Range Date Column Type with LOWER function Always Return Empty Data, but Query Works in PostgreSQL

Hi everyone,

I'm facing an issue where a query in Laravel, using both Eloquent and Query Builder, always returns empty results, even though the same query works perfectly fine when run directly in PostgreSQL (using DataGrip).

Here’s the code I’m using in Laravel: Using Eloquent:

$pertemuans = Pertemuan::query()
    ->whereRaw('LOWER(waktu) BETWEEN ? AND ?', [
        '2024-09-23 02:41:18',
        '2024-09-23 02:43:18'
    ])
    ->get();

Using Query Builder:

$pertemuans = DB::table('kelas.pertemuan')
    ->whereRaw('LOWER(waktu) BETWEEN ? AND ?', [
        '2024-09-23 02:41:18',
        '2024-09-23 02:43:18'
    ])
    ->get();

However, both queries return empty results, but when I try the same query directly in PostgreSQL, it works fine and returns the expected data:

SELECT * FROM "kelas"."pertemuan"
WHERE LOWER(waktu) BETWEEN '2024-09-23 02:41:18' AND '2024-09-23 02:43:18';

Additional Information:

• Database: PostgreSQL
• Laravel version: 9.52.4
• PHP version: 8.3.3
• Data type of the waktu column: tstzrange

Question: Why does this query work in PostgreSQL but always return empty data in Laravel? Has anyone encountered this issue before or have any suggestions for a fix?

Thank you so much for your help!