Method processDates

api/src/services/payload.ts:416–546

* Knex returns `datetime` and `date` columns as Date.. This is wrong for date / datetime, as those * shouldn't return with time / timezone info respectively

(
		fieldEntries: [string, FieldOverview][],
		payloads: Partial<Record<string, any>>[],
		action: PayloadAction,
		aliasMap: Record<string, string> = {},
		aggregate: Aggregate = {},
	)

	 * shouldn't return with time / timezone info respectively
	 */
	processDates(
		fieldEntries: [string, FieldOverview][],
		payloads: Partial<Record<string, any>>[],
		action: PayloadAction,
		aliasMap: Record<string, string> = {},
		aggregate: Aggregate = {},
	): Partial<Record<string, any>>[] {
		// Include aggegation e.g. "count->id" in alias map
		const aggregateMapped = Object.fromEntries(
			Object.entries(aggregate).reduce<string[][]>((acc, [key, values]) => {
				acc.push(...values.map((value) => [`${key}->${value}`, value]));
				return acc;
			}, []),
		);

		const aliasFields = { ...aliasMap, ...aggregateMapped };

		for (const aliasField in aliasFields) {
			const schemaField = aliasFields[aliasField];
			const field = this.schema.collections[this.collection]!.fields[schemaField!];

			if (field) {
				fieldEntries.push([
					aliasField,
					{
						...field,
						field: aliasField,
					},
				]);
			}
		}

		const dateColumns = fieldEntries.filter(([_name, field]) => ['dateTime', 'date', 'timestamp'].includes(field.type));

		const timeColumns = fieldEntries.filter(([_name, field]) => {
			return field.type === 'time';
		});

		if (dateColumns.length === 0 && timeColumns.length === 0) return payloads;

		for (const [name, dateColumn] of dateColumns) {
			for (const payload of payloads) {
				let value: number | string | Date = payload[name];

				if (value === null || (typeof value === 'string' && /^[.0 :-]{10,}$/.test(value))) {
					payload[name] = null;
					continue;
				}

				if (!value) continue;

				if (action === 'read') {
					if (typeof value === 'number' || typeof value === 'string') {
						value = new Date(value);
					}

					if (dateColumn.type === 'timestamp') {
						const newValue = this.helpers.date.readTimestampString(value.toISOString());