I did it once to pull out data from a spreadsheet into a database. Specifically, I needed "${DataType}${Month}"
for each month for 3 different datatypes
Iirc, i used an sql pivot (or unpivot) in that query too
Usually, it’s situations like this where you’re parsing data from strings, and you need some glue code to interface between the input data, and the date library you’re using to actually resolve the datetime
When I’m doing mental roll call (to make sure I’ve not trapped one somewhere), i call them
In order of their acquisition