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.