FastLoad Timestamp Conversion error 6760

Tools

FastLoad Timestamp Conversion error 6760

I am bumping into timestamp conversion error when loading to timestamp column with time zone. The table in the column define as 

device_dt_ut TIMESTAMP(0) WITH TIME ZONE

snippet of fastload:

0005 DEFINE

        device_dt_ut (VARCHAR(32)),

0008 INSERT INTO xxxxxx.stg_flurry_app_event_f (device_dt_ut,


Data :

 2012-11-16 24:11:45-07:00

An suggestion would be appriciated

1 REPLY
Senior Apprentice

Re: FastLoad Timestamp Conversion error 6760

 The data seems to be in the right format, but 2012-11-16 24:11:45-07:00 is not a valid timestamp, there's no 24 hours.

Dieter