Could you give an example, please? (This is the first time I'm doing an SQL Query...):
I use a simple query where datetime field is an TIMESTAMP(6) value with this format 'YYYY-MM-DD hh:mm:ss.fff',
I've tried to use that query but it seems that it doesn't accept the format:
LOAD HOST, DATE_C;
SQL SELECT HOST, TO_DATE(DATE_C,'AAAA-MM-DD hh:mm:ss.fff')
Ans this is the error: SQL##f - SqlState: S1000, ErrorCode: 1821, ErrorMsg: [Oracle][ODBC][Ora]ORA-01821: date format not recognized
Thank you so much!