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.world
    link
    fedilink
    English
    arrow-up
    4
    ·
    10 months ago

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

    • PracticalReputation@lemmy.worldOP
      link
      fedilink
      English
      arrow-up
      2
      ·
      10 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.