I have a csv file I’d like to read, seems I’m correct other than parsing the date. The csv file shows the date like so: "“2023-03-04 07:54:33”

I’ve tried a bunch without success. I feel it should be:

date-format %Y-%M-%D %H:%M:%S

But nope, getting an error it can not parse it.

  • IronyHammer@lemmy.worldEnglish
    4·
    6 months ago

    You have %M as both month and minute. Double check what each individual date part is meant to be.

    • PracticalReputation@lemmy.worldOPEnglish
      2·
      6 months ago

      Thanks for pointing that out, it was one of the problems, the solution was using: date-format %Y-%m-%d %H:%M:%S

      Next problem was I forgot to add skip 1 at the top.