Hi guys, i have been working on Query Reports on Frappe, and not able to format the date within Query Report that i made, the Query is
Select DATE_FORMAT(SO_I.modified, ‘%m/%d/%Y %H:%i’) as “SO Item Modified::120” from
tabSales Order Item
SO_I;
This query is correctly running within MariaDB
06/30/2021 17:29
but gives error in Frappe
ValueError: unsupported format character 'm' (0x6d) at index 36