I started to follow the official documentation of gcp in order to import my csv data to an instance on cloud spanner spanner, but I’m getting thhis error:

Error java.time.format.DateTimeParseException: Text ‘2024-05-30THH24:16:30.892’ could not be parsed at index 10

I’m using this command to generate the csv file:

psql -h localhost -U myuser -d mydatabase -c “Copy (SELECT id, TO_CHAR(created_at, ‘YYYY-MM-DD”T”HH24:MI:SS.MS’) AS created_at FROM mytable) To STDOUT With CSV DELIMITER ‘,’;” > /mycarpet/.csv

The table has this configuration:

id character varying(10) NOT NULL,
created_by character varying(50),

On the configuration of the job I’m setting: dateFormat=yyyy-MM-dd hh:mm:s

Any idea, how I can solve this?