I'm using Tim's wonderful sql tool (https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/ if you haven't seen it yet), and I've encountered something weird if I run the following query in the tool

select CURRENT_TIMESTAMP AS report_date, * FROM accountingperiod

The output I get is as pictured. CURRENT_TIMESTAMP gets resolved to a date, not to a datetime. Is there a way to get full datetime output, similar to e.g. createddate in saved searches?

Use TO_CHAR to format it how you like --- otherwise it follows your account’s default date formatting.

TO_CHAR(CURRENT_TIMESTAMP, 'DD/MM/YYYY HH24MISSxFF')

thanks so much!