Get lastmodifieddate down to the second, not just the day

AI generated answer (using internal Slack threads):

To get the

lastmodifieddate

down to the second, you can use the

to_char

function in a search as suggested in the first thread. However, if you are trying to get the seconds from

record.getValue

, it seems that NetSuite does not provide this level of granularity. In the second thread, it is suggested to use

to_char

to convert the date to a format you find convenient, and then use

to_date

to convert back the result from

to_char

. This can be used to sort by the date. In the third thread, if you are trying to find out why items are having their last modified date updated, you can try a system notes saved search. However, not all system notes that are recorded show up on the System Notes subtab. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

TO_CHAR(date,'DD.MM.YYYY mm:ss')

Thanks! I read on Tim Dietrich's blog that you can also use 'DS TS' as the format parameter for TO_CHAR and get similar results.