How to select Point In Time record

Question

I have a MariaDB 10.2.21.

My table contains records that include a 'ChangeDate' field like this: '2019-09-18 10:57:26'.

I want to do a SELECT based on a timestamp, and get the nearest previous record to return.

This allows me to do a 'point-in-time' selection providing me with field values as they were at that moment.

I seeked StackOverflow but do no recognize a proper solution. Any hints? Thanks!

Answer 1

Try following Query

SELECT * 
  FROM my_table 
 WHERE ChangeDate < '2019-09-18 10:57:26' 
 ORDER 
    BY ChangeDate DESC 
 LIMIT 1