How can I get the number of minutes since a transa...
# suiteqlb
burkybang
09/16/2022, 6:54 PMHow can I get the number of minutes since a transaction has been created?
s
Sandii
09/16/2022, 7:07 PM(CURRENT_DATE - createddate)*24*60Sandii
09/16/2022, 7:15 PM Copy code
(CURRENT_DATE - TO_DATE(TO_CHAR(createddate, 'YYYY-MM-DD hh:mi:ss'), 'YYYY-MM-DD hh:mi:ss')) * 24 * 60b
burkybang
10/03/2022, 7:49 PMThank you!