Query Search using Date - Result empty error

Developers Dev talks
1

Hi,

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
Thanks

2

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

3

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

timestamp BETWEEN 1688187600 AND 1698814799