Query Search using Date - Result empty error


In db_get_array or db_get_row function to get record using date column as search params.

The Query:

$date = date('Y-m-d'); or $date = date('Y-m-d',strtotime('2023-08-07'));
used with strtotime or without strtotime and also used **fn_parse_date** 
db_get_array("SELECT * FROM ?:some_table WHERE date = ?i", $date);

The Query Always return empty array or row result.

How to get record using date as param in cscart

It depends on the table you use. If it is default table, you should use date in Unix format in your requests

Yes, like @ecomlabs suggests, it should be something like:

timestamp BETWEEN 1688187600 AND 1698814799