Get data where date greater than date now

Server Code
1

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 > ’ “+Date.now()+” ’ ";

but the result is not returned based on that condition.

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

any help

2

Him @adel_kasno

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

Regards,
Marina