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.