When I run a saved search of messages, via UI or SuiteScript, I believe the date/time of the message appears in the timezone of the current user. However, when I run this in SuiteQL, I think it’s coming out in GMT. Does anyone know how to get the SuiteQL datetime (I’m using TO_CHAR) to come out the same as the result I’d get via Saved Search? Note that I’m using SuiteQL instead of SavedSearch because SavedSearch isn’t giving me the list of attachments, only gives me this

Very long SQL statement. Will be replaced in Java.

For me, the most frustrating thing, unfortunately for you and me, it is a normal situation. And I don’t have a solution 😞 It is always GMT …. date, datetime, and time types stored in database are always GMT, but when presented to the current user are FORMATTED to timezone string ….

I ended up doing a saved search AND a SuiteQL and combining the results. Bleagh.