The contents of this documentation are not contractual and in no way constitute an extension to, or restriction of, the contractual warranty clauses.Ĭontact Schneider Electric today at Contents However, those who wish to make a more "advanced" use of our products may find it necessary to consult our nearest distributor in order to obtain additional information. It contains information necessary for the proper use of the products. Validity Note The present documentation is intended for qualified technical personnel responsible for the implementation, operation and maintenance of the products described. No responsibility is assumed by Schneider Electric for any consequences arising out of the use of this material. PLEASE NOTE Electrical equipment should be installed, operated, serviced, and maintained only by qualified personnel.
#Citect int decimal place manual
October 2010 edition for Vijeo Citect Version v7.20 Manual Revision Version v7.20. GENERAL NOTICE Some product names used in this manual are used for identification purposes only and may be trademarks of their respective companies. All other brands and products referenced in this document are acknowledged to be the trademarks or registered trademarks of their respective holders. dBASE is a trademark of dataBased Intelligence, Inc. in the United States and other countries. Novell, Netware and Netware Lite are either registered trademarks or trademarks of Novell, Inc. DigiBoard, PC/Xi and Com/Xi are trademarks of Digi International Inc.
#Citect int decimal place windows
MS-DOS, Windows, Windows NT, Microsoft, and Excel are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
#Citect int decimal place Pc
Citect, CitectHMI, Vijeo Citect, Vijeo Citectlite and CitectSCADA are registered trademarks of Schneider Electric IBM, IBM PC and IBM PC AT are registered trademarks of International Business Machines Corporation. TRADEMARKS Schneider Electric has made every effort to supply trademark information about company names, products and services mentioned in this manual. Further, Schneider Electric reserves the right to revise this publication at any time without incurring an obligation to notify any person of the revision.ĬOPYRIGHT © Copyright 2010 Schneider Electric All rights reserved. No rounding occurs.Legal Notice DISCLAIMER Schneider Electric makes no representations or warranties with respect to this manual and, to the maximum extent permitted by law, expressly limits its liability for breach of any warranty that may be implied to the replacement of this manual with another. The TRUNC() function truncates a number to a given decimal place. Here’s an example that uses the TRUNC(number) function: SELECT TRUNC(1.2573, 2) Here, we specified two decimal places, but we could have specified any number. T he ROUND() function rounds a number to a given decimal place. Here’s an example that uses the ROUND(number) function: SELECT ROUND(1.2573, 2) Of course, you’re not just limited to two decimal places – you can specify more decimal places in your format model if required. Here’s what happens when I remove the fm from the previous example: SELECT Although, if you do this, you might end up with trailing zeros, even when using the 9 format element. You can omit this if you don’t mind the result being padded. I should point out that fm is a format modifier that removes any padding that may be applied to the result. Using 9s in this case, resulted in a radix character, but no decimal places. If I don’t want the trailing zeros, I can change the 0 characters to 9s. The reason I used zeros after the decimal character, is to provide trailing zeros if required. In this case the original number has more than two decimal places, and so the result simply truncates it to the specified number of zeros that follow the decimal/radix character ( D) in the format model. Here’s an example that uses the TO_CHAR(number) function: SELECT TO_CHAR(1.2345, 'fm99D00') Or you can use functions like ROUND(number) and TRUNC(number) to round or truncate the number to your required number of decimal places. When using Oracle Database, you can use functions like TO_CHAR(number) to return numbers as a string, formatted to two decimal places (or however many decimal places you require).
0 kommentar(er)
