Prisma•2y ago

Filtering time

I am using mysql db with prisma

this are the fields in my schema

  time_from  DateTime  @db.Time(0)
  time_to    DateTime  @db.Time(0)

  time_from  DateTime  @db.Time(0)
  time_to    DateTime  @db.Time(0)

I want to filter using these feilds.

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?

Thanks

Prisma•2y ago

ForcedToCode

Filtering time

I am using mysql db with prisma

this are the fields in my schema

  time_from  DateTime  @db.Time(0)
  time_to    DateTime  @db.Time(0)

  time_from  DateTime  @db.Time(0)
  time_to    DateTime  @db.Time(0)

I want to filter using these feilds.

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,
},

 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?

Thanks

Filtering time

Similar Threads

Filtering time

Similar Threads

Similar Threads

Similar Threads