[PostgreSQL] Inserting a pre-defined date format[solved-ish]
Posted: Fri Jun 29, 2007 8:02 am
Hello,
I have a task to migrate some data from CSV files to a PostgreSQL database, and currently I am having difficulty with the Date field on some of the tables - the format is within the CSV's and PostgreSQL does not like this.
How do I specify a date format when importing a CSV file?
Thanks in advance.
I have a task to migrate some data from CSV files to a PostgreSQL database, and currently I am having difficulty with the Date field on some of the tables - the format is
Code: Select all
D/M/YYYY HH:MM:SSHow do I specify a date format when importing a CSV file?
Thanks in advance.