https://issues.apache.org/ooo/show_bug.cgi?id=125482
Kay <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOT_AN_ISSUE --- Comment #2 from Kay <[email protected]> --- In the first case, if you are literally entering "4th quarter 94" this is not an acceptable date format ( when you create the field you should also see displayed what the format is), and so it converts any string to 30/12/99. What you need for the second item, is not a DATE field but a TIMESTAMP field, so changing the format for a DATE does not really change the type of data associated with a DATE so that is why this is occurring. It might be helpful for you to find some introductory site on relational databases that discussed data types. Closing as "NOT AN ISSUE". -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
