How can I take the difference of two TIMESTAMP columns with SuiteQL

AI generated answer (using internal Slack threads):

To take the difference of two TIMESTAMP columns with SuiteQL, you can use the

extract

function in combination with the

systimestamp

function. Here is an example of how you can do this:

sql
extract(day from (systimestamp-{custrecord_datetime})) || ' day(s), ' || 
extract(hour from (systimestamp-{custrecord_datetime})) || ' hour(s), ' || 
extract(minute from (systimestamp-{custrecord_datetime})) || ' minute(s), ' || 
round(extract(second from (systimestamp-{custrecord_datetime}))) || ' second(s)'

In this example,

{custrecord_datetime}

is the custom field you want to compare with the current timestamp. The

extract

function is used to get the difference in days, hours, minutes, and seconds. The

systimestamp

function is used to get the current timestamp. Please note that the

systimestamp

function uses the server time, while the Date/Time field is stored/displayed with your timezone. However, the comparison is performed with both in the same timezone. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******