Hello everyone,
Probably this question will be asked earlier but I could not found it. So if there is another post about this, please let me know!
I have connected a robot in UiPath Studio with an Oracle SQL Database. This robot sends 5 variables (Sequence, Price, Size, Side, Time) which has to be inserted in the table of the database. The table has also 5 columns: Sequence, Price, Volume, Side, Time.
With the variables Sequence, Price, Size & Side I have no trouble inserting them into the table (columns: Sequence, Price, Volume, Side) but with Time I am struggling.
The original time which the robot extracts with an API from a website is in Epoch format. The robot converts this into dd-MM-yyyy HH:mm:ss-format. So an output would be like 06-09-2023 11:18:53
I have checked in Oracle SQL Developer what the sysdate-format is with SELECT sysdate FROM dual;
The output was 06-09-23. So I ran the command: alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS';
When I run the command SELECT sysdate FROM dual; now, I get the output: 06-09-2023 11:22:53
So the formats look the same but I am still getting the error ORA-01843.
What am I doing wrong?
Many, many thanks for your replies!