Does anyone know how I can get the difference in m...
# suiteql
b
Does anyone know how I can get the difference in minutes from the current_date and the lastmodifieddate?
Copy code
SELECT 
	type,
	tranid,
	id,
	BUILTIN.DF(custbody_rfi_trm_temp_shipstatus) as tempstatus,
	TO_CHAR(createddate, 'DD/MM/YYYY HH24:MM:SS') AS createddatetime,
	TO_CHAR(lastmodifieddate, 'DD/MM/YYYY HH24:MM:SS') AS lastmodifieddatetime,
	TO_CHAR(current_date, 'DD/MM/YYYY HH24:MM:SS') AS currentdate
FROM
	transaction
WHERE 
	transaction.type
LIKE '%ItemShip%'
AND
	BUILTIN.DF(transaction.custbody_rfi_trm_temp_shipstatus) = 'PROCESSING'
ORDER BY lastmodifieddate desc
r
try this for min. round(to_number(logoff_time-logon_time)*1440)
👍 1