Q: using DB connect how to enter data in oracle DB for "Date" data type?
i am trying output data from "splunk DB Connect " to oracle Database for "DATE" datatype. For other data types (like VARCHAR) i am able to insert data to Oracle Db but just for Date datatype its not working.
I tried strf and strp functions to convert date to match oracle date format.
i have also tried almost all the date format which internet is suggesting me (or my normal insert function in SQL is working) but nothing is working for DB connect.