61
Wombat
6y

Imagine a database table where dates were saved as strings from raw user input. Then do migration to other database with table where dates are datetime.

Yep. That's me. 😶

I hate humans. 😧🔫

Especially those who try to be original like:
11|Sept.|2016 or 13;Juni;17

There are rules in this world, damn. 😥

Comments
  • 27
    At least you did not get an entry like: yup, today it is!
  • 12
    that's why I am always validate user input before storing it
  • 14
    Might not be popular, but have you considered parsing it using php? It's a fucking miracle what the DateTime class is able to parse sometimes...
  • 24
    Wait until you encounter literally "on the thirty-first day in the month of August anno Domini MMXVIII".
  • 2
    What the dddddduuuuuck
  • 4
    @Wack I did and it worked like every time in PHP: like a charm. But I had to search for the right methods.
  • 2
    Well that's why I always save Unix timestamps
  • 3
    @gitpush Hahahaha you made me laugh so fucking hard, thanks! (also, are you still on signal? :/)
  • 2
    @linuxxx great to hear that 😀😀
    Honestly no, had to restore my phone and when installed again I couldn't find the group. I also lost access to riot and forgot my credentials 🤦🏼‍♂️
    Any private channel where I can give you my number or you have it?
Add Comment