0

I am using the Rest API to run SuiteQL, something like the following:

--header 'Authorization: Bearer <> \
--header 'Prefer: transient' \
--header 'Content-Type: application/json' \
--header 'Cookie: NS_ROUTING_VERSION=LAGGING' \
--data-raw '{
    "q": "SELECT * from customer limit 10"
}'

Now I noticed that there are fields like dateLastModified that is type timestamp, but in the return result, there's only the date part - "08/12/2023" for example.`

How do I force the API to ALWAYS return the full date time object for timestamp type?

Sometimes I need to write dynamic queries without knowing which columns are timestamp format so using a function like SELECT TO_CHAR(dateLastModified, 'YYYY-MM-DD HH:MI:SS') as c FROM customer doesn't always work for me.

Jack Duan
  • 3
  • 2

0 Answers0