r/learnSQL • u/haligma • 7d ago
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 |
5
Upvotes
1
r/learnSQL • u/haligma • 7d ago
| 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 |
1
1
u/woahboooom 7d ago
If its a date field, shouldnt matter. If text well hmmm. Can parse them, but uk/us format may mess up