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?