DateTime Conversion in PostgreSQL

Question

How can I convert 'dd-MM-yyyy HH:mm:ss.fff' to 'yyyy-MM-dd HH:MI:SS.MS' format so that I can store timestamp values in a PostgreSQL 8.0.2 timestamp column?

Answer 1

Presumably you don't have to convert the format, just switch to european datestyle before issuing COPY.

The command is:

SET datestyle to 'DMY';