• 0 Posts
  • 6 Comments
Joined 2 years ago
cake
Cake day: December 31st, 2023

help-circle

  • 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