Problem: I want to calculate the difference (in minutes) between the max and min of a date column in a table, but I'm not sure of the syntax.
Could anyone help me?
Printable View
Problem: I want to calculate the difference (in minutes) between the max and min of a date column in a table, but I'm not sure of the syntax.
Could anyone help me?
EMP: NAME, JOINDATE
select (max(joindate) - min(joindate))*24*60 from emp;
Does this match with your requirement?