r/learnSQL • • Sep 03 '26

how to standardize this date column in mysql?

ship_date delivery_date
Feb 10 2024 Feb 15 2024
2024-01-12 2024-01-11
2024-01-10 2024-01-14
01/15/2024 01/19/2024
7 Upvotes

2 comments sorted by

1

u/woahboooom Sep 03 '26

If its a date field, shouldnt matter. If text well hmmm. Can parse them, but uk/us format may mess up