This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```TO_CHAR ( Contact.lastModifiedDate, 'YYYY-MM-DD HH:MI:SS' ) AS lastModifiedDate ```
I want this to be in UTC format

<@U01DHK58Q1G> -- did this work for you? I get an error when using this function on `transaction.lastModifiedDate`, in my IDE it shows this field stored as a `timestamp` without any TZ info.

<@U055QFKNU8N> yea this was the end result:
```TO_CHAR( SYS_EXTRACT_UTC(Contact.lastModifiedDate), 'YYYY-MM-DD HH24:MI:SS' ) AS lastModifiedDate```