Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
How to return the full date/time object in SuiteQL?
I am using the query API to run queries using SuiteQL, something like the following:
curl --location --request POST 'https://<account id>.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql' \
--header 'Authorization: Bearer <> \
--header 'Prefer: transient' \
--header 'Content-Type: application/json' \
--header 'Cookie: NS_ROUTING_VERSION=LAGGING' \
--data-raw '{
"q": "SELECT * from transaction left join customer on transaction.entity=customer.id"
}'
Now I noticed that there are fields like createddate that are of type date time, but still in the return result I am getting only the date part - "29/12/2022" for example.
My question is: How do I tell the API to return the full date time object?
0