Sort with 'FROM_UNIXTIME' doesn't work

So i’m trying to make a query sorting a nested association using

sort => 'FROM_UNIXTIME(‘date’)

but it seems it didn’t work. My guess is that sort don’t support that function.
Any ideas?

Assuming that the date column is a timestamp, surely you can just sort on that directly?

Unfortunely, its a bigint. Its not my database so i would have to stick around with it.

Why do you need to convert the date from bigint? If it’s a timestamp value, you can just sort it in UTC.