mysqlpoint-in-time

How to select Point In Time record

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!

Solution

  • Try following Query

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