Can't read date fields from oracle

There lot of messages like " metabase.driver.sql-jdbc.execute Error reading :oracle column 8 CLOSE_TIME TIMESTAMP" in the log.

  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_2) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.4 Safari/605.1.15",
    "vendor": "Apple Computer, Inc."
  "system-info": {
    "": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "1.8.0_162-b12",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "",
    "java.version": "1.8.0_162",
    "": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "25.162-b12",
    "": "Windows Server 2012 R2",
    "os.version": "6.3",
    "user.language": "en",
    "user.timezone": "Europe/Moscow"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "h2",
    "run-mode": "prod",
    "version": {
      "tag": "v0.34.1",
      "date": "2020-01-13",
      "branch": "release-0.34.x",
      "hash": "265695c"
    "settings": {
      "report-timezone": null

Hi @Max.A
Which version of ojdbc8.jar are you using - 19.3?
Is that the only error message?
What is the actual database column type? It looks like timestamp, but in your title you write “Can’t read date …”.

Hi flamber, yes, it was jdbc problem. I putted it in plugin calalog but didn’t delete standard library.
I left only jdbc8.jar and now its ok

1 Like


Same here. Using ojdbc8.jar 19.3.
My date format is stored as VARCHAR2 with the format "30/05/2017 10:44:03"
I have tried everything.
Any advice?

Thanks in advance,

@phmazzoni That's not the same problem. You don't have date types, but strings. You would have to create a database view to cast the strings into a timestamp type.

Metabase currently doesn't support casting in the Data Model, but that will be possible in 0.39 for some types and extended more in 0.40

Unfortunately I don't have access to the db.
Do you think there is a development branch that I can test these features?

Thanks again!

@phmazzoni Our code is public, but this is not been created/finished yet, so no.
You can follow some of the progress here:

1 Like