#557 closed bug (fixed)
Entry Prior to 1/1/1970 Limitation with Date Type for an Attribute in a Template
| Reported by: | prcua | Owned by: | |
|---|---|---|---|
| Priority: | minor | Milestone: | 7.2.1 |
| Component: | Core | Version: | 7.2 |
| Keywords: | Cc: |
Description
I created an extended properties template that contains an attribute defined as DATE type to represent a date of birth entry. When I enter a date prior to 1/1/1970, I receive the following error:
Data truncation: Incorrect datetime value: '1969-04-15 11:00:00' for column 'ld_datevalue' at row 1; SQL [n/a]; nested exception is org.hibernate.exception.DataException?: Data truncation: Incorrect datetime value: '1969-04-15 11:00:00' for column 'ld_datevalue' at row 1
Change History (2)
comment:1 Changed 10 years ago by car031
- Component changed from User Interface to Core
- Priority changed from Major to Minor
- Resolution set to fixed
- Status changed from new to closed
comment:2 Changed 10 years ago by prcua
Note: See
TracTickets for help on using
tickets.
I noticed that this has been changed to fixed, I assume this means that the fix is present for the upcoming milestone 7.2.1 scheduled for release on 5/31/2015.
Is it possible for me to get a hotfix to apply to my current system to correct this for now as we have the date attribute in many of our templates we are ready to adopt for our business, but the employees cannot enter the date prior to 1/1/1970.
Thanks