Inserting timestamp in Oracle
<p>I'm trying to insert the row below into Oracle database, but I get error
<code>[22008][1830] ORA-01830: date format picture ends before converting entire input string</code></p>

<pre><code>insert into tbl (coldate, start, end) 
values (
TO_DATE('2005-03-04 02:04:30', 'YYYY-MM-DD HH24:MI:SS'),
TO_TIMESTAMP('2005-03-23 09:06:51.055000', 'YYYY-MM-DD HH24:MI:SS'), 
TO_TIMESTAMP('2005-04-26 23:32:59.430000', 'YYYY-MM-DD HH24:MI:SS')
);
</code></pre>