Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add time-zone into database tables' timestamp/date fileds #1928

Open
taojing2002 opened this issue May 16, 2024 · 0 comments
Open

Add time-zone into database tables' timestamp/date fileds #1928

taojing2002 opened this issue May 16, 2024 · 0 comments
Milestone

Comments

@taojing2002
Copy link
Contributor

Currently, Metacat stores the timestamp and date data without the timezone information. It interprets they are with the default timezone of JVM (system). So this can cause an issue if the operator change the default timezone of the host.

In the systemmetadata table, it has:

date_uploaded           | timestamp without time zone |
date_modified           | timestamp without time zone |

In the access_log table, it has:

date_logged | timestamp without time zone |

In the both xml_documents and xml_revisions table, it has

date_created | date |
date_updated | date |

The date type doesn't have timezone information either. The value looks like:

 date_created | date_updated 
--------------+--------------
 2024-04-30   | 2024-04-30
 2024-04-30   | 2024-04-30
@taojing2002 taojing2002 added this to the 3.1.0 milestone May 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant