Year 2001 being converted to 0001

Get Help
1

dateOracle dateMetabase

Oracle View to Metabase table view

Is there available fix for this?

2

which version you're running?

3

Using now v0.41.0. Same issue with previous version. Data sits on Oracle 12c.

4

@weng Post "Diagnostic Info" from Admin > Troubleshooting.
Which version of ojdbc8.jar?

5

@flamber Yes, ojdbc8.jar.

6

@weng

  1. Post "Diagnostic Info" from Admin > Troubleshooting
  2. Post which version of ojdbc8.jar you are using: https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html
7

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/94.0.4606.61 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "14.0.2+12-46",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "https://java.oracle.com/",
"java.version": "14.0.2",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "14.0.2+12-46",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Asia/Singapore"
},
"metabase-info": {
"databases": [
"oracle",
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2021-10-06",
"tag": "v0.41.0",
"branch": "release-x.41.x",
"hash": "c529fe2"
},
"settings": {
"report-timezone": null
}
}
}

8

I also tried using the latest jdk/jvm 17 but still got the same issue.
Thanks.

9

@weng I keep asking for the same things, but you do not give answers for that. I have no idea how to reproduce, but you're welcome to open an issue with complete details about your system and how to reproduce.
https://github.com/metabase/metabase/issues/new/choose

10

I replied to all of your question. Please see trail. If I miss something, may I please know the said question you keep on asking?

11

@weng
Post ojdbc8.jar version - as I have asked for two times before.

12

It is a 12.2.0.1 JDBC Thin driver ( ojdbc8.jar )

13

@weng Okay, go and download at least 19.3 (19c) or newer:
https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html

14

The 19.3 and new version of ojdbc8 did not fix the issue.

15

@weng Okay, then you need to provide a DDL, so it's possible to reproduce the problem.

16

What specific DDL do you need?

17

@weng
I have absolutely no idea which column types you're using.
You need to provide enough information so other people can reproduce your problem.

18

Hi,
Please see the ddl below;
Name Null? Type

D_START NOT NULL DATE
D_END NOT NULL DATE

19

@weng
Try SELECT TO_CHAR(D_START, 'YYYY-MM-DD') FROM your_table
Oracle has a terrible way of presenting and storing dates, so perhaps it's caused by something there.
If that doesn't help you, then I don't know what's wrong and I don't think I can help you. Try contacting an Oracle DBA.