ora-01861 Questions
6
When I try to execute this snippet:
cmd.CommandText = "SELECT alarm_id,definition_description,element_id,
TO_CHAR (alarm_datetime, 'YYYY-MM-DD HH24:MI:SS'),severity,
problem_text,status FROM air...
3
Solved
How can I convert this string date to datetime in oracle.
2011-07-28T23:54:14Z
Using this code throws an error:
TO_DATE('2011-07-28T23:54:14Z', 'YYYY-MM-DD HH24:MI:SS')
How can this be done?
...
4
Solved
I want to execute a simple function in Oracle. The signature is defined as follows:
CREATE OR REPLACE FUNCTION NewCaseListForValidation
(
p_fromDate in DATE,
p_toDate in DATE,
p_rowCount in INT...
Arredondo asked 3/2, 2011 at 9:1
2
Solved
Possible Duplicate:
Simple Oracle query: literal does not match format string
I am getting the following error:
INSERT INTO CatalogueEntry VALUES('2001-12-10', 2, 14.99, 1, 0)
ERROR...
Tuchun asked 22/11, 2012 at 18:45
1
© 2022 - 2024 — McMap. All rights reserved.