Hello everyone, I have a database in oracle, which has a table with several columns and one of them in DATE format: rrrr-mm-dd HH24:MI:SS.
When I query for this column in dremio, it returns it in rrrr-mm-dd format (no hours, minutes or seconds). Converting in date-time does not work because the hours, minutes, and seconds return them as zeros.
What can I do so that when I consult Dremio for this column it comes with the hours, minutes and seconds?
I appreciate your help, Greetings!