Hello, new to using SuiteQL REST API. Is there a way to alter/set sql session parameter so that all results from the query impacted? Example: when retrieving data from the

transaction

table, all

TIMESTAMP

fields are truncated/formatted like

M/DD/YYYY

....If I was able to alter the sql session with something like:

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

-- then that would save me from having to use the

TO_CHAR

for every

TIMESTAMP/DATETIME

column in a table.

No, as you're not actually interacting with a native Oracle session. There's an abstraction layer

@CD Thank you for the response. Do you have recommendations for a work around? Or do users typically use the

TO_CHAR()

function to get around this?