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