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:

nestjs-paginate/src/paginate.ts

Lines 331 to 342 in f85337d

	const condition: WherePredicateOperator = {
	operator: 'ilike',
	parameters: [alias, `:${property.column}`],
	}
	if (['postgres', 'cockroachdb'].includes(queryBuilder.connection.options.type)) {
	condition.parameters[0] = `CAST(${condition.parameters[0]} AS text)`
	}
	qb.orWhere(qb['createWhereConditionExpression'](condition), {
	[property.column]: `%${query.search}%`,
	})

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?