How to update a table setting date as '11/30/2010 12:30:01 PM' in particular records?

[seemantika]

kindly plz anyone can tell me what is the query for updating a table having one column createddatetime which is like '11/30/2010 12:30:01 PM'. i want to set some more records to that values using update command. how?
i can do it using for update.. by manually one by one...
but how to do it using update command? plz help me in this..
i tried this command Like this
"update <table_name> a
set a.createddatetime=to_char('11/30/2010 12:30:01 PM','mm/dd/rrrr hh:nn:ss PM')
where ......."

but it shows invalid number error...

[rski]

Maybe like that

update <table_name> a
set a.createddatetime=to_char('11/30/2010 12:30:01 PM','mm/dd/rrrr hh:mi:ss PM')
 

[amitpatel66]

Try this:

SQL> ed
Wrote file afiedt.buf
 
  1* UPDATE test_1 set a = TO_CHAR('11/30/2010 12:30:01 PM','MM/DD/RRRR HH:MI:SS PM')
SQL> /
UPDATE test_1 set a = TO_CHAR('11/30/2010 12:30:01 PM','MM/DD/RRRR HH:MI:SS PM')
                              *
ERROR at line 1:
ORA-01722: invalid number
 
 
SQL> ed
Wrote file afiedt.buf
 
  1* UPDATE test_1 set a = TO_DATE('11/30/2010 12:30:01 PM','MM/DD/RRRR HH:MI:SS PM')
SQL> /
 
1 row updated.
 
SQL> select TO_CHAR(a,'MM/DD/RRRR HH:MI:SS PM') from test_1;
 
TO_CHAR(A,'MM/DD/RRRRH
----------------------
11/30/2010 12:30:01 PM
 
SQL>