I’m trying to set a specific field in a record where the legacy code has used a DDMM format DATETIME as a char. I want to be able to find one specific value that matches something and basically change that one field. Super simple stuff, right? I know for a fact that if I query using to_char(SOME_DATETIME, ‘DDMM’) = ‘0311’