I have a table 'Messages' containing a column 'Posted' of type timestamp without time zone.
I need to get the newest table entry. The current SQL is
- Code: Select all
SELECT Max(m.Posted) AS LastMessage FROM Messages m
System.Data.OleDb.OleDbException - "Accessor validation was deferred and was performed while the method returned data. The binding was invalid for this column or parameter."
The Max() function has been successfully used with Integer type columns, but fails with timestamps. I do not have a workaround for this either.