Hello all,
I'm new :) Looking for some guidance. I usually need to query huge tables by date. The date column is formatted like this: 2021-09-24 13:03:17. I typically need the datasets by month, from 2019-01 to etc. I use to_char(CALENDAR_DT, 'YYYYMM') to set my condition but it takes a long time. I wonder if this is the best way to do it?
Thank you!