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)
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
- Post “Diagnostic Info” from Admin > Troubleshooting
- Which version of
ojdbc8.jar
are you using? - What is the Oracle column type of
CREATED_ON
- What’s the Field Type the same column? Admin > Data Model > (db) > (table) > (column)