All Forums Tools
17 Nov 2012
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

mk
dnoeth 4628 posts Joined 11/04
19 Nov 2012

 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

Dieter

You must sign in to leave a comment.