At V9.0 and above must all date fields in a SQL clause have the ODDAT_ prefix (and associated date format) or are epoch date specifications still functional. I've read documentation but am unclear if the epoch date specifications should still work. Thank you
If you want to know about IBM CMOD Date formats, there's an article in the CMOD wiki: https://cmod.wiki/index.php?title=Date_and_Time_formats_in_Content_Manager_OnDemand
That might give you a little insight into how that works. Let me know if you have any questions, and I'll try my best to answer them (and get the wiki updated as well!).
-JD.