Date and Time from database not showing complete


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?


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",
"": "OpenJDK Runtime Environment",
"java.runtime.version": "",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "",
"java.version": "",
"": "OpenJDK 64-Bit Server VM",
"java.vm.version": "",
"": "Linux",
"os.version": "5.4.0-107-generic",
"user.language": "en",
"user.timezone": "GMT"
"metabase-info": {
"databases": [
"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

@mgfeal And what is the actual database column type?
And which version of ojdbc8.jar are you using?

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


Which version of ojdbc are you using? Provide the SHA1:

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?

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