Get data where date greater than date now

i have a table with column with type date called leavingDate
and i’m trying to fetch data where leavingDate greater than date now.
my query as this:

" leavingDate > ’ “” ’ ";

but the result is not returned based on that condition.

i think the problem is cause is returning date utc as timestamp, and the leavingDate in db as local timezone.

any help

Him @adel_kasno

Try to use the next whereClause 'leavingDate > now()'