And the real maddening part is that search engines have been so enshitfied to make way for AI that’s wrong like 9/10, so you’re forced to rely on it for answers because if you try google, the snake wraps around and eats it’s own tail giving you an AI answer! 
So many helper functions. All I said was, use a json file to create sql insert statements and have the date in timestamp format, expecting it to use To_timestamp. It created a helper function for parsing each datepart, then another to cast the result into To_timestamp.