Jeff Smith | 8 Nov 17:18 2007
Picon

RE: RE: RE: [Error]ORA-01810: format code appears twice

Working with dates is a PITA, yes/no?
 
Let Toad help you!
 
View > Code Snippets.
 
We have all of the date options, and all of the to_date and to_char functions as well, with comments and examples so you know what each is and how it should be used.
 

From: toad <at> yahoogroups.com [mailto:toad <at> yahoogroups.com] On Behalf Of Hudson, James - DNR
Sent: Thursday, November 08, 2007 9:45 AM
To: toad <at> yahoogroups.com
Subject: RE: [toad] RE: [Error]ORA-01810: format code appears twice

Your 'yyyymmddhhmmss' should be 'yyyymmddhhmiss'.
 
The code for months is MM
 
The code for minutes is MI
 
I know this one because I've made the same mistake many times.
 
-- jim

James F. Hudson
Wisconsin Department of Natural Resources
Madison, WI
(608) 267-0840

 

From: toad <at> yahoogroups.com [mailto:toad <at> yahoogroups.com] On Behalf Of ZHENG Yuan (SCC-IT)
Sent: Thursday, November 08, 2007 4:57 AM
To: toad <at> yahoogroups.com
Subject: [toad] RE: [Error]ORA-01810: format code appears twice


Dear members:

Could any one solve my problem? I got an error message" ORA-01810:
format code appears twice".So how can I do with it?

INSERT INTO WIP_SCC_NVIDIA_MAIN
(SEQNO, PRODORDERNUMBER,
BATCHNUMBER,PARTNUMBERBUILDAS,SCHEDULESHIPOUTDATE,
REVISEDSHIPOUTDATE, MEMORYPARTNUMBER,
MEMORYBATCHNUMBER,MEMORYQTYUSED,SUBSTRATEPARTNUMBER, SUBSTRATEQTYUSED,
TESTPROGRAM,BRIDGEPARTNUMBER, BRIDGEBATCHNUMBER,BRIDGEQTYUSED,OTHER7,
OTHER8,OTHER9,
OTHER10,PLANT,STATUS_FLAG,UPDATE_TIME,B2B_FETCH_FLAG,B2B_FETCH_DATE)
VALUES ( '66','1376850','QG6054.LC','ASCK804-740H-1GA3',
to_date('20071112','YYYYMMDD'),to_date('','YYYYMMDD'),'',
'','','480-0046-NA3DA-AS3', '209',' ', ' ',' ','', ' ',' ',' ','
','SCC', '',
to_date('20071108184413','YYYYMMDDHHmmSS'),'Y',to_date('20071108184413',
'YYYYMMDDHHmmSS'))

Thanks.
YUAN

__._,_.___

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

Gmane