Problem with TO_DATE from PRO*C (gives error 904)
From: Jan Olav Eide <jan-olav.eide_at_noner.abb.telemax.no>
Date: 4 Jan 1995 13:20:34 GMT
Message-ID: <3ee7b2$o38_at_ratatosk.uninett.no>
jan-olav.eide_at_noner.abb.telemax.no Received on Wed Jan 04 1995 - 14:20:34 CET
Date: 4 Jan 1995 13:20:34 GMT
Message-ID: <3ee7b2$o38_at_ratatosk.uninett.no>
EXEC SQL BEGIN DECLARE SECTION
char datestr[30];
EXEC SQL END DECLARE SECTION
strcpy(datestr,"17-12-1995 13:12:21");
EXEC SQL UPDATE alarm_status
SET GMT = TO_DATE(ds,'DD-MM-YYYY HH24:MI:SS')
WHERE ALARM_ID = :alarm_id;
Any hints highly appreciated.
jan-olav.eide_at_noner.abb.telemax.no Received on Wed Jan 04 1995 - 14:20:34 CET