Help with SUiteQL when querying with language set as japanese
Hi Team.
I was trying to fetch SystemNotes data using SuiteQL. But the query doesnt seem to work in japanese language. The query is as follows:
I was trying to fetch SystemNotes data using SuiteQL. But the query doesnt seem to work in japanese language. The query is as follows:
SELECT DISTINCT sn.oldvalue, sn.newvalue, sn.date, snf.label as field FROM piaccesslog AS pi JOIN systemnote AS sn ON sn.recordid = pi.recordid JOIN systemnotefield AS snf ON snf.key = sn.field WHERE sn.recordid = 30 AND sn.recordtypeid = -30 AND pi.action = 12 AND sn.date >= to_date('03/23/2025 01:21 pm', 'MM/DD/YYYY HH:MI am') AND sn.date < to_date('03/23/2025 01:22 pm', 'MM/DD/YYYY HH:MI am')
The error seems to be it at this point :
to_date('03/23/2025 01:21 pm', 'MM/DD/YYYY HH:MI am')
specifically at the HH:MI am part. Can anyone please suggest any solution for this ? Thanks in advance
