lundi 2 février 2015

How to Insert TIMESTAMP Column into Redshift

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