C#, Oracle, datetime
Posted on 2016-08-17
i have been having a hard time retrieving rows from Oracle in my C# program.
the are two rows with CHANGED date greater than AUGUST 10th. if i could itget working in TOAD i probably get the code working.
column definition TIMESTAMP(6).
the data in the column '14-AUG-16 08.51.51.043000 AM'.
in the program:
the TODATE is not working for me as i cant get the format with the literal as month.
i cant get a two year formatter. with a month that is literal(AUG).
SELECT * FROM XXX.XXX WHERE changed > TO_DATE('10-AUG-16 1:00:00 AM','DD-MON-YYYY HH:MI:SS AM');
ORA-01843: not a valid month.
any help would greatly appreciated.
SELECT * FROM XXX.XXXXXXX WHERE changed > TO_DATE('10-AUG-16 1:00:00 AM','MON-DD-YYYY HH:MI:SS AM')
Error at line 1
ORA-01843: not a valid month