I need to enter both date and time in a table in Oracle in a column which is of type 'Date'. In the 'update table' query, I use the following for conversion:
to_date('dateString','yyyy-mm-dd hh24:mi:ss');
But I am getting this error:
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
I have googled for this query and found that it is perfectly alright.
The dateString will be a date viz. '2007-06-14 09:31:24.762'.
Any body has any inputs on this?
Thanks in Advance.
to_date('dateString','yyyy-mm-dd hh24:mi:ss');
But I am getting this error:
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string
I have googled for this query and found that it is perfectly alright.
The dateString will be a date viz. '2007-06-14 09:31:24.762'.
Any body has any inputs on this?
Thanks in Advance.