Searching for Dates in Non Standard Formats MySQL

[ctilley83]

NestJS 10.3 Typeorm: 0.3.17 Is it possible to search for dates using mysql's STR_TO_DATE(str,format) function? I have defined a few columns as searchable, and it would be nice to pass in a format so the date format on the frontend can be used. I'm not sure if that's possible through this package or any of the ORMs supported by NestJS.

[Helveg]

Hi there! Take a look at the source code here:

https://github.com/ppetzold/nestjs-paginate/blob/f85337d5553520684389e77cc5024feb848f89f3/src/paginate.ts#L331-L342

We seem to apply the ilike operator. Since I don't know the specific MySQL feature you're talking about, maybe you can see how to implement this feature?