Another example, if you have a table where one column is strings like that:
TO_DATE ('5/25/2010 2:24:35 PM', 'MM/DD/YYYY HH:MI:SS PM')
Edited by: Frank Kulash on May 25, 2010 3:36 PM
SELECT TO_DATE (col_d, 'MM/DD/YYYY HH:MI:SS PM') FROM table_x;
oraclebeginner1231 wrote:Here's one example.
Can you give me an example for insert, i have a string and i need to convert it to date and then insert..
thanks for your patience..
INSERT INTO my_table (id, entry_date) VALUES (123, TO_DATE ('5/25/2010 2:24:35 PM', 'DD/MM/YYYY HH:MI:SS PM')) ;