I created a table in Redshift:
create table myTable (
dateTime TIMESTAMP NOT NULL,
...
);
However, when I try to insert a record that contains a dateTime of, I get an error from stl_load_errors.
20080215 04:05:06.789
Since I took this timestamp from the docs, I would've expected it to have worked.
The error logs from Redshift show:
Invalid timestamp format or value [YYYY-MM-DD HH24:MI:SS]
However, I'd like to include 3 extra seconds, example: 2015-02-01 15:49:35.123.
How do I need to modify my timestamp field to insert it with the extra precision on seconds?
Aucun commentaire:
Enregistrer un commentaire