Date is not coming on the header

When running the sql query the date format is not comming properly.kindly suggest for the created on field

Hi @AVIJIT
Which version of Metabase?
You’re saying that when you run an SQL query it’s wrong, but does that mean that it works correctly, when you’re using the GUI Builder?
I guess you’re querying Oracle, but what’s the column type of CREATED_ON?
And what’s the Field Type the same column? Admin > Data Model > (database) > (table) > (column) :gear:

I am using meta base .35

Created on is the date type which is usly

01-04-2020 12:50:00 000000

@AVIJIT
That’s a strange format, normally a database would return yyyy-MM-dd hh:mm:ss.ssssss

  1. Post “Diagnostic Info” from Admin > Troubleshooting
  2. Which version of ojdbc8.jar are you using?
  3. What is the Oracle column type of CREATED_ON
  4. What’s the Field Type the same column? Admin > Data Model > (db) > (table) > (column) :gear: