I am using Oracle database. I have a table called "
TESTbst365体育投注网址大全" where the dates/timestamps(These are stored as "Char" in my case) are stored in the following format. Now I want to retrieve the records of last twelve months based on today's date. What would be the correct way to do that?
TESTCOLUMN ------------ 2019-06-28-02.01.07.327240 2020-06-28-04.49.12.480240 2020-06-28-05.05.10.681240