Ora 01898 Error Oracle
Contents |
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full too many precision specifiers in oracle Time Job Ways to Get Help Expand Search Submit Close Search Login Join 01898 area code Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Oracle Error too many precision specifiers sql "To many precesion Specifiers" Want to Advertise Here? Solved Oracle Error "To many precesion Specifiers" Posted on 2010-07-22 Oracle Database 1 Verified Solution 11 Comments 1,753 Views Last Modified: 2013-12-07 I have two
Oracle Truncate Date
different scripts running that update a table. Table: UPdateNum UpdateDate Value1 Value2 The scripts were planned to ... SCRIPT1 Check if todays date exists in the table and IF YES UPDATE VALUE1 not interupting any other column in that Record IF NO INSERT sysdate into UpdateDate and calculated number into Value1 leaving Value2 NULL SCRIPT2 Check if todays date exists in the table and IF YES UPDATE to_date VALUE2 not interupting any other column in that Record IF NO INSERT sysdate into UpdateDate and calculated number into Value2 leaving Value1 NULL So by running both scripts i shd get the record populated by value 1 and 2 and still retaining 1 record per DATE BUt....... I get an error saying that "To many precesion Specifiers" I executed parts of SQL and identiied that error is in UPDATE BLOCK of my CODE given below Anyhelp wud be greatly appreciated. :) Im on Oracle 10g Enterprise -- CODE from SCRIPT 1 UPDATE SALES SET EMP_MGR_TOTAL_CHNAGES = total WHERE TRUNC(UPDATEDATE, 'MM/DD/YYYY') = TRUNC(sysdate, 'MM/DD/YYYY'); IF SQL%ROWCOUNT = 0 THEN -- no update INSERT INTO SALES (UPDATENUM,UPDATEDATE,EMP_MGR_TOTAL_CHANGES,EMP_TERM_TOTAL_CHNAGES) VALUES (SALES.UPDATENUMSEQ.NEXTVAL,SYSDATE,total,NULL); END IF; -- CODE from SCRIPT 2 UPDATE SALES SET EMP_TERM_TOTAL_CHNAGES = total WHERE TRUNC(UPDATEDATE, 'MM/DD/YYYY') = TRUNC(sysdate, 'MM/DD/YYYY'); IF SQL%ROWCOUNT = 0 THEN -- no update INSERT INTO SALES (UPDATENUM,UPDATEDATE,EMP_MGR_TOTAL_CHANGES,EMP_TERM_TOTAL_CHNAGES) VALUES (SALES.UPDATENUMSEQ.NEXTVAL,SYSDATE,NULL,total); END IF; data was found in the date format picture Action: Check the syntax of the date format picture and retry. Version 10g too many precision specifiers Cause: While trying to truncate or round dates, extra data was found in the date format picture Action: Check the syntax of the date format picture and retry. Version 9i too many precision specifiers Cause: While trying to truncate or round https://www.experts-exchange.com/questions/26349500/Oracle-Error-To-many-precesion-Specifiers.html dates, extra data was found in the date format picture. Action: Check the syntax of the date format picture and retry. Version 8i too many precision specifiers Cause: While trying to truncate or round dates, extra data was found in the date format picture. Action: Check the syntax of the date format http://www.oracle-error.com/8i/ora-01898.html picture and retry. This entry was posted in Oracle 10g Errors, Oracle 11g Errors, Oracle 8i Errors, Oracle 9i Errors, Oracle Database Server Messages. Bookmark the permalink. Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Currently you have JavaScript disabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page. Click here for instructions on how to enable JavaScript in your browser. Search for: Recent Commentsabhi on ORA-24237oracle-error on ORA-24237abhi on ORA-24237Mike TAILOR on ORA-12154oracle-error on ORA-39776Support services ? Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support Archives April 2015 Categories EXP Messages Oracle 10g Errors Oracle 11g Errors Oracle 8i Errors Oracle 9i Errors Oracle Database Server Messages Recent Posts XML-30017 XML-30016 XML-30014 XML-30013 XML-30012 Oracle-Error.com 2016Zerif Lite powered by WordPress Product: Impromptu Version: Any http://stackoverflow.com/questions/19730189/sql-sum-data-by-hour Problem: When running a report against Oracle that contains a type-in prompt to filter a datetime field, the following error is received: ORA-01898 too many precision specifiers too many Solution: Check the properties of the prompt in Prompt Manager. Ensure that the prompt type is set to datedate and not date. If the prompt is set to date then you will receive this error too many precision when filtering against a datetime field. Resolving the problem Check the properties of the prompt in Prompt Manager. Ensure that the prompt type is set to datedate and not date. If the prompt is set to date then you will receive this error when filtering against a datetime field. Historical Number 108852 Document information More support for: Cognos Series 7 Impromptu Software version: Impromptu 6.0 Operating system(s): Platform Independent Reference #: 1332721 Modified date: 12 September 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL SUM DATA by Hour up vote 1 down vote favorite 1 I have 3 columns ID TIMESTAMP CALLS I need to sum up number of call by hour. example ID TIMESTAMP CALLS 1 10-01-2013 01:00:23 23 2 10-01-2013 03:00:23 55 3 10-01-2013 05:00:23 2369 4 10-01-2013 04:00:23 12 5 10-01-2013 01:00:23 1 6 10-01-2013 12:00:23 99 7 10-01-2013 01:00:23 22 8 10-01-2013 02:00:23 3 Output result should be something like TimestampHOUR Totalcalls 10/1/2013 01:00 46 10/1/2013 02:00 3 10/1/2013 03:00 55 10/1/2013 04:00 12 10/1/2013 05:00 2369 10/1/2013 11:00 99 I already tried used datepart,hour(timestamp) but I guess it is not supported by my version of oracle. sql oracle oracle11g timestamp share|improve this question edited Nov 1 '13 at 15:53 asked Nov 1 '13 at 15:44 user206168 1632517 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted SELECT TRUNC(timestamp, 'HH24') AS hour, COUNT(*) AS TotalCalls FROM some_table GROUP BY TRUNC(timestamp, 'HH24') share|improve this answer edited Nov 1 '13 at 16:03 answered Nov 1 '13 at 15:48 Mureinik 103k2054104 I am getting error ORA-01898: too many precision specifiers line 3. –user206168 Nov 1 '13 at 15:54 1 @user206168, yes, you should change 'DD/MM/YYYY hh24' by 'hh24' or simple by 'hh'. –danihp Nov 1 '13 at 16:02 1 @danihp correct, thanks. Fixed my answer. –Mureinik Nov 1 '13 at 16:04 Thanks a lot it works perfectly fine. –user206168 Nov 1 '13 at 16:27 @Mureinik I have one question. you see how I don't have 06:00 through 10:00 PM data? is there anyway to show those times also and show count as 0? –user206168 Nov 1 '13 at 18:56 add a comment| up vote 1 down vote You should trunc your date time to hour, then group. Sample rounding to hour: select TRUNC (sysdate,'hh') from dual see results share|improve this answer answered Nov 1 '13 at 15:49 danihp 21.9k13079 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email