REST API + NetSuite...getting only date in the date/time fields (select lastModifiedDate from Item) returns only the date portion and in a very nonstandard format for integration. How do we get the full timestamp. Also sorting by lastModifiedDate or createdDate throws an unexpected error but can sort by other fields. Full link with request/response here - https://netsuiteprofessionals.com/question/rest-api-datetime-sorting/

try to use to_char, to convert to whatever format you find convenient. then, a different field, where you use to_date, to convert back, the result from to_char. use this last one to sort by.