Products | Versions |
---|---|
TIBCO Collaborative Information Manager | - |
Not Applicable | - |
Resolution:
Description:
============
Attempting to modify a record with an attribute defined as type date of value 0001-01-01 (YYYY-MM-DD) results in an error:
GEN-7056: Error converting string Übernahme Datum to date for attribute 1-01-01 00:00:00.
Environment:
===========
All TIBCO Collaborative Information Manager versions.
All platforms hardware and virtual.
Cause:
=====
This is a limitation of the UI. Internally the date is stored as java Date, which is defined as:
=================================================================================================
A thin wrapper around a millisecond value that allows JDBC to identify this as an SQL DATE value. A milliseconds value represents the number of milliseconds that have passed since January 1, 1970 00:00:00.000 GMT.
=================================================================================================
Resolution:
==========
Be sure all dates are later than January 1, 1970 00:00:00.000 GMT. If earlier dates are required, a string attribute can be used.