DATE_DIFF
now accepts a new parameter, absolute
, that maintains polarity on the expression when set to FALSE
:DATE_DIFF('2025-01-23T13:30:45', '2025-01-23T10:00:00', absolute: FALSE)
returns:
{
"days" => -0.15,
"hours" => -3.51,
"minutes" => -210.75,
"seconds" => -12645,
"weeks" => -0.02,
"units" => {
"days" => 0,
"hours" => -3,
"minutes" => -30,
"months" => 0,
"seconds" => -45,
"weeks" => 0,
"years" => 0,
},
}