I'm working with Prisma in Node.js. But I'm having bit of trouble. Actually I want to find Data on the basis of Date only But in my Database(Postgres) date is stored with datetime format, i.e 2022-09-13 16:49:44.712811+05. But I want that when pass date only which is 2022-09-13. It returns me the data against this date, doesn't matter what ever datatype it is. Sample Data:
[
{
designation: "VP",
last_active: 2022-09-13 16:49:44.712811+05 //DateTime
},
{
designation: "Admin",
last_active: 2022-09-25 19:55:44.712811+05 // datatype is dateTime
}
]
Thanks in Advance!