I have time stamp in my data file, but jasper is not recognizing it. What should I do?

Posted on July 17, 2017 at 1:10am

Data example:

created_at	Well id	Depth (m)	Temperature (°C)	Absolute Humidity (%H)	Latitude (°N)	Longitude(°E)
2017-06-15 17:29:39 UTC	1	100.3333333	31.21	16.53333333	26.84243	93.58101

ankit.singhal

Joined: Jun 28 2017 - 7:55am

Last seen: 3 years 2 weeks ago

Need more info:

1) what is the error? provide stack trace if possible

2) what type of data source? xml, csv, database, if database, what flavor?

3) are you getting an incompatible datatype when referencing that column as a timestamp? what do you mean by "not recognizing it"

darth_fader - 3 years 3 weeks ago

1 Answer:

Posted on July 18, 2017 at 4:35pm

1. Make sure in your data adapter you have a proper mask for the date/time fields.

2. Make sure the Java type of the field is appropriate as well, something like java.util.Date.

Friendly User

22483

Joined: Oct 8 2009 - 5:59am

Last seen: 1 hour 21 min ago