Home
Reading
Searching
Subscribe
Sponsors
Statistics
Posting
Contact
Spam
Lists
Links
About
Hosting
Filtering
Features Download
Marketing
Archives
FAQ
Blog
 
Gmane
From: Jeff Smith <jeff.smith <at> quest.com>
Subject: RE: RE: RE: [Error]ORA-01810: format code appears twice
Newsgroups: gmane.comp.db.oracle.toad.free
Date: Thursday 8th November 2007 16:18:10 UTC (over 9 years ago)
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.
 [cid:[email protected]]

________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
Hudson, James - DNR
Sent: Thursday, November 08, 2007 9:45 AM
To: [email protected]
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: [email protected] [mailto:[email protected]] On Behalf Of ZHENG
Yuan (SCC-IT)
Sent: Thursday, November 08, 2007 4:57 AM
To: [email protected]
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
 
CD: 22ms