Is it possible to return a max value from a table ...

# squarelibraries

[Andrew O Hart]

Is it possible to return a max value from a table in SQLDelight?
I'm trying

retrieveMostRecentLastModificationDate:
SELECT MAX(Information.lastModificationDate) FROM Information LIMIT 1;

And it is returning Query<RetrieveMostRecentLastModificationDate>
I just need to return the most recent date from the table, so I would expect it to return as an Int or a Long as we are storing it using toEpochMilliseconds

[eygraber]

What happens if you remove the LIMIT 1 (max should only ever return one value)?

[Andrew O Hart]

It shows this:

[Andrew O Hart]

[Andrew O Hart]

Not sure on why its trying to return the SQL Query name

[alec]

its just a wrapper, it probably holds the value you want

[alec]

it has to be wrapped i assume because your last modification date is nullable

[Andrew O Hart]

yeah calling .MAX on it returns it.
That explains it more, thanks Alec