You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/08/21 14:01:04 UTC
[Issue 125482] New: Tables:Date field is not updating
https://issues.apache.org/ooo/show_bug.cgi?id=125482
Issue ID: 125482
Issue Type: DEFECT
Summary: Tables:Date field is not updating
Product: Base
Version: 4.1.0
Hardware: All
OS: Windows 8
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: qualkenqa@outlook.com
1.Create a database
2.Then create a table with one field as "date"
3.When inserting the data in the "date field" ex:(4th quarter 94) and click on
enter. It is converted into (30/12/99).
4.When update that field like ex:(2nd quarter 13) again it converted to
(30/12/99).
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125482] Tables:Date field is not updating
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125482
Kay <ks...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |kschenk@apache.org
Resolution|--- |NOT_AN_ISSUE
--- Comment #2 from Kay <ks...@apache.org> ---
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.
[Issue 125482] Tables:Date field is not updating
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125482
--- Comment #1 from Qualken <qu...@outlook.com> ---
1.Create a database
2.Then create a table with one field as "date"
3.Then go to table design view and change format code in format example like
DD:MM:YY HH:MM
4.When inserting the data in the "date field" like 10/08/94 16:35 and i am
trying to enter another date field it again displays as 10/08/94 00:00, the
time is missing and displaying as zero's
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.