Year 2001 being converted to 0001

dateOracle dateMetabase

Oracle View to Metabase table view

Is there available fix for this?

which version you're running?

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

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

@flamber Yes, ojdbc8.jar.


  1. Post "Diagnostic Info" from Admin > Troubleshooting
  2. Post which version of ojdbc8.jar you are using:

"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",
"": "OpenJDK Runtime Environment",
"java.runtime.version": "14.0.2+12-46",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "",
"java.version": "14.0.2",
"": "OpenJDK 64-Bit Server VM",
"java.vm.version": "14.0.2+12-46",
"": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "Asia/Singapore"
"metabase-info": {
"databases": [
"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

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

@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.

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?

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

It is a JDBC Thin driver ( ojdbc8.jar )

@weng Okay, go and download at least 19.3 (19c) or newer:

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

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

What specific DDL do you need?

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

Please see the ddl below;
Name Null? Type


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.