Resolved: extract data from 9pm the previous day to 9pm of current day in DB2

Question:

how can we extract data from 9pm the previous day up until 9pm of current day using a timestamp column in DB2, please help

Answer:

This should work but I’m not at a machine to test it right now…

If you have better answer, please add a comment about this, thank you!