Oracle Database Discussions

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!

insert date value to a table

SasiOct 30 2012 — edited Nov 29 2012

hi

i tried to update a table to insert date to a date field. while i am executing the query it throws an error message like,

"
ORA-01830: date format picture ends before converting entire input string
01830.00000- "date format picture ends before converting entire input string"
*Cause:
*Action:
Vendor code 1830Error at Line:1"

my update query is added below:

UPDATE PS_OBJCMTP_TMP SET LASTUPDOPRID='PPLSOFT' ,LASTUPDDTTM =TO_DATE('2002-02-11-12.14.09.000000', 'YYYY-MM-DD-HH24.MI.SS') WHERE OBJECTID1= 3 AND OBJECTVALUE1 = 'EDIMAPPROPOP' AND OBJECTID2= 0 AND OBJECTVALUE2 = ' ' AND OBJECTID3= 0 AND OBJECTVALUE3 = ' ' AND OBJECTID4=0 AND OBJECTVALUE4 = ' '

any one tell me how to solve this issue.

This post has been answered by Mark Malakanov (user11181920) on Oct 30 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 24 2012

Added on Oct 30 2012

#general-database-discussions

11 comments

720 views