Hi,
We have a database with two fields like that:
But when we browse the database using Metabase, it only shows the date:
We are using the latest version from Metabase.
How can we modify it?
Thanks!
Hi @mgfeal
Post "Diagnostic Info" from Admin > Troubleshooting.
And what is the actual database column type?
{
"browser-info": {
"language": "es-ES",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:98.0) Gecko/20100101 Firefox/98.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.4.0-107-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"oracle"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MariaDB",
"version": "10.7.3-MariaDB-1:10.7.3+maria~focal"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.5"
}
},
"run-mode": "prod",
"version": {
"date": "2022-04-07",
"tag": "v0.42.4",
"branch": "release-x.42.x",
"hash": "7c3ce2d"
},
"settings": {
"report-timezone": null
}
}
}
I'm waiting for our Database department to send us the database column type. But we found this using the filter:
We use ojdbc11.jar
Thanks
@mgfeal
Which version of ojdbc are you using? Provide the SHA1:
https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
SHA1: 3e588fed4618a39c7d655bfc1159ecb57fabc217
Our database team replied us:
These values are DATE type.
The internal precision of this field includes hours and minutes and seconds, but how it is represented in the output of a query depends on the mask you use and, if you don't use a mask, the client and environment variables it has.
For example, if in my sqlplus client I query the date_created field for a specific record, without specifying anything else, I get the following format:
If I want the output to include the time, I have to use the to_char function with whatever mask I deem necessary:
How can we do that in Metabase?
Thanks!
@mgfeal Okay, so you are using ojdbc11.jar version 21.5.
Oracle is a quirky database. The column type is a DATE, so Metabase expects only dates. You would have to create a different column type or modify the driver to always include times even for dates.