![]() I tried setting the datestyle setting to ISO,MDY and SQL,MDY to no avail.I also attempted to modify the field type in the target table to character to force the fields to be read as strings, but that didn't work either.Īny ideas? Ideally I would like to have the data directly read into the target table as dates, but would settle for character strings. HINT: Perhaps you need a different "datestyle" setting. to save the setting for the next time you connect to postgres Hi rski, Thanks a lot for your quick response. ![]() I get the following error on import: ERROR: date/time field value out of range: " 0:00:00" I'm looking to import a series of CSV files that contain a datetime field in the format of m/dd/yyyy h:mm:ss into a PostgreSQL table using the native /copy command. The SET DATESTYLE command changes the DATESTYLE run-time parameter for the current session.
0 Comments
Leave a Reply. |