time_from: { lte: dateFrom ? new Date(dateFrom) : undefined, gte: dateTo ? new Date(dateTo) : undefined,},
time_from: { lte: dateFrom ? new Date(dateFrom) : undefined, gte: dateTo ? new Date(dateTo) : undefined,},
I know that i cannot filter time directly in primsa but i dont want to use raw query because i have lots of other optional filters in this query which gets complicated using raw query.
When i fetch data from this table i get
1970-01-01T23:37:32.000Z
1970-01-01T23:37:32.000Z
for the time fields even though there is only time in the db. I already tried using time with this date
1970-01-01
1970-01-01
but still i dont get any results. Is there any way to handle this?