Dates Not Importing Correctly

[cmarchan]

Working with dates is tricky. It may well be that your csv dates are formatted differently than your browsers.

Issues with importing time in database

I am trying to bulk import opening and closing times into the database through a CSV and for some reason the date/time that shows up in the database is 5 hours behind the actual time in the CSV file. For example if the date/time in the CSV is Jan 1, 2020 11:00 AM, once I upload the CSV to the database the date/time that shows up in the database is Jan 1, 2020 6:00 AM. Or if the date/time is Jan 1, 2020 11:00 PM in the CSV, the date/time that shows up in the database is Jan 1, 2020 6:00 PM. Se…