SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update date field

469192May 2 2006 — edited May 2 2006

Hello,
I'm trying to update a date field with a specified date time value...please help with the syntax...here's what i have currently
SS

UPDATE PROC_TIMES SET NEW_TIME = TO_DATE(04/25/2006 10:22:06,'DD-MON-YY hh24:mi:ss') WHERE REQ_NUM = 'R033635012EPAK' AND REQ_SUFFIX = 'BXX';

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2006

Added on May 2 2006

2 comments

4,075 views