Timeline for MySQL reads Date columns in Excel as DateTime?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2018 at 10:22 | comment | added | user161095 | If you also need time: YYYY-MM-DD hh:mm:ss | |
| Jul 14, 2016 at 14:22 | comment | added | cxwf | yes. see my edit. it could be 1.3.6's bug | |
| Jul 14, 2016 at 14:08 | comment | added | Bibhuti Bhusan Padhi | So are you still facing the same issue? | |
| Jul 14, 2016 at 12:26 | comment | added | cxwf | Hi Bibhuti, thanks for the reply. I tried that before and MySQL always convert them to mm/dd/yyyy no matter what formats are used in Excel | |
| Jul 13, 2016 at 21:37 | history | answered | Bibhuti Bhusan Padhi | CC BY-SA 3.0 |