Hi everybody, cmd.CommandText = "SELECT alarm_id,definition_description,element_id, TO_CHAR (alarm_datetime, 'YYYY-MM-DD HH24:MI:SS'),severity, problem_text,status FROM aircom.alarms WHERE status = 1 and TO_DATE (alarm_datetime,'DD.MM.YYYY HH24:MI:SS') > TO_DATE ('07.09.2008 09:43:00', 'DD.MM.YYYY HH24:MI:SS') order by ALARM_DATETI...
Why does the following error occur on Line 7 of the query below? Error: ORA-01861: literal does not match format string Query: 01: SELECT hour 02: FROM (WITH all_hours AS 03: (SELECT TO_DATE ('2000-01-01', 'yyyy-mm-dd') 04: + NUMTODSINTERVAL (LEVEL - 1, 'hour') hour 05: FROM DUAL 06: ...
I'm pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I spend another 10 minutes with this ) I'll ask it here in parallel. What's wrong with the following statement: select to_date( '30/10/2009 18:27:35', 'DD/MM/YYY HH24:MI:SS') from dual The error message is: Err...
Hello I am trying to run this oracle query in toad and I am getting the above mentioned error. How can I fix it? INSERT INTO IMAGE ( IMAGE_SEQ_NO,BLDG_ID,BU_ID,DT_TAKEN, NEGATIVE_NO,FILENAME,FILE_TYPE,DESCRIPTION, STORAGE_SRCE,DOC_ID,PICT_SRCE_TYPE,TAKE_BY, INFO_SRCE,DOC_REF_NO,DOC_TYPE,SUB_DOC_TYPE, DDW_IMAGE_DOC_...