Importing Time / Date data

sigmachiuta
Kilo Guru

‎12-27-2014 01:33 PM

I am importing data from Excel.   The problem I am having is errors in the import log...I am looking in Excel and the format of the field is

2010-03-11 10:26:28

And in my transform map I have specified the date format seen below, so i am confused why i am receiving this error .   It looks like the date is correct but it is trying to format 03-11-2010 without time.   This is an excel sheet that i have reformatted to use yyy-MM-dd hh:mm:ss   Is Snow not recognizing the changed format?

Capture.PNG


com.glide.db.impex.transformer.TransformCoercionException: Unable to format 03-11-2010 using format string yyyy-MM-dd hh:mm:ss for field u_open_time

Preview file
7 KB
0 Helpfuls
  • 5,375 Views
11 REPLIES 11

Victor Ruiz
Tera Guru
In response to Harish KM

‎04-17-2015 09:39 AM

Thanks Harish....


0 Helpfuls

Greg45
Tera Contributor

‎07-10-2019 01:03 PM

Someone above mentioned the "issue with midday coming in as midnight".  For that, simply change the format on the transformation map to HH instead of hh. Assuming you supply a 24 hour value, you'll have a problem with your 12's if you don't format as yyyy-MM-dd HH:mm:ss.  (default is yyyy-MM-dd hh:mm:ss )

I post this here because google points here for similar searches.