Results for TRUNC


1 to 20 of 54 results. Prev  Next
Results per page:   20  | 40


Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Numb er Class

trunc()parameter specified. Syntax const Number trunc( int decPlace) const; Parameter Description decPlace The

DML Reference, 10g Release 1 (10.1)

TRUNC

TRUNCThe TRUNC function truncates either a number or a date and time value. Because the syntax of the … TRUNC function is different depending on the whether it is being used for a number or a date and time … value, two separate entries are provided: TRUNC (for dates and time) TRUNC (for numbers)

DML Reference, 10g Release 1 (10.1)

TRUNC

TRUNC (for numbers)When you specify a number as an argument, the TRUNC function truncates a number to a specified … number of decimal places. Return Value DECIMAL Syntax TRUNC ( number,  truncvalue ) Arguments

DML Reference, 10g Release 1 (10.1)

TRUNC

number-19 Truncating to the Right of the Decimal Point The following statement SHOW TRUNC (15.79, 1) returns … this value 15.7 Example 24-20 Truncating to the Left of the Decimal Point The following statement SHOW TRUNC (15.79, -1) returns this value 10

DML Reference, 10g Release 1 (10.1)

TRUNC

TRUNC (for dates and time)When you specify a date and time value as an argument, the TRUNC function returns the date and time … value is truncated to the nearest day. Return Value DATETIME Syntax TRUNC ( datetime_exp,  fmt ) Arguments

DML Reference, 10g Release 1 (10.1)

TRUNC

datetime-expthe format models shown in Table 24-7, "Format Models for TRUNC for Dates and Time". A format model … indicates how the date and time number should be truncated. Table 24-7 Format Models for TRUNC for … the value of the NLS_DATE_FORMAT option is DD-MON-YY, then this statement: SHOW TRUNC ('27-OCT-92','YEAR') returns this value: 01-JAN-92

SQL Reference, 10g Release 1 (10.1)

TRUNC (number)

TRUNC (number)Syntax trunc_number::= Description of the illustration trunc_number.gif Purpose The TRUNC (number … truncate numbers: SELECT TRUNC(15.79,1) "Truncate" FROM DUAL; Truncate ---------- 15.7 SELECT TRUNC(15.79,-1) "Truncate" FROM DUAL; Truncate ---------- 10

SQL Reference, 10g Release 1 (10.1)

TRUNC (date)

TRUNC (date)Syntax trunc_date::= Description of the illustration trunc_date.gif Purpose The TRUNC (date … TRUNC Date Functions" for the permitted format models to use in fmt. Examples The following example … truncates a date: SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR') "New Year" FROM DUAL; New Year --------- 01-JAN-92

SQL Reference, 10g Release 1 (10.1)

ROUND and TRUNC Date Functions

ROUND and TRUNC Date FunctionsTable 7-13 lists the format models you can use with the ROUND and TRUNC date functions and the … truncated to the day with a time of midnight. Table 7-13 Date Format Models for the ROUND and TRUNC Date

DML Reference, 10g Release 1 (10.1)

24 TRAP to ZSPELL

24 TRAP to ZSPELLTRIGGERSTOREOK TRIM TRUNC TRUNC (for dates and time) TRUNC (for numbers) UNHIDE UNIQUELINES UNRAVEL

Utilities, 10g Release 1 (10.1)

9 Field List Reference

Combinations of SQL OperatorsEXTERNAL "TRUNC(RPAD(:field1,6,'0'), -2)" field1 POSITION(1:8) INTEGER EXTERNAL "TRANSLATE(RTRIM

Deployment and Performance Guide, 10g Release 1 (10.1)

A Services Deployment Example

Step 4. Enable Service, Module, and Action Monitoringconfiguration col AGGREGATION_TYPE format a20 trunc heading 'AGGREGATION' col PRIMARY_ID format a20 … trunc heading 'SERVICE' col QUALIFIER_ID1 format a20 trunc heading 'MODULE' col QUALIFIER_ID2 format … a20 trunc heading 'ACTION' select * from DBA_ENABLED_AGGREGATIONS. The query output would look like

Deployment and Performance Guide, 10g Release 1 (10.1)

A Services Deployment Example

Step 1. Add Service Prioritiesformat a30 trunc col attribute format a20 trunc col consumer_group format a20 trunc SELECT ATTRIBUTE

SQL Reference, 10g Release 1 (10.1)

ROUND (date)

ROUND (date)the nearest day. The date expression must resolve to a DATE value. See Also: "ROUND and TRUNC Date

Globalization Support Guide, 10g Release 1 (10.1)

4 Datetime Datatypes and Time Zone Support

Datetime SQL Functions… Oracle does not perform internal conversion for the ROUND and TRUNC functions. Table 4-1 shows the

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

ROW_NUMBER Function, TO_CHAR(TRUNC(SUM(amount_sold), -5), '9,999,999,999') SALES$, ROW_NUMBER() OVER (ORDER BY TRUNC(SUM

Guide, 10g Release 1 (10.1)

14 Loading and Transformation

Transformation Using SQL/*+ APPEND NOLOGGING PARALLEL */ INTO sales SELECT product_id, customer_id, TRUNC(sales_date), 3 … VALUES (product_id, today, promotion_id, 3, product_cost, product_price) SELECT TRUNC(s.sales_date … sales_activity_direct s, products p WHERE s.product_id = p.prod_id AND TRUNC(sales_date) = TRUNC … (SYSDATE) GROUP

Globalization Support Guide, 10g Release 1 (10.1)

4 Datetime Datatypes and Time Zone Support

Function Descriptionthe fmt format model TRUNC (date) Returns date with the time portion of the day truncated to the

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

8 XSQL Pages Publishing Framework

Producing XML Datagrams from SQL QueriesFlightSchedule WHERE TRUNC(ExpectedTime) = TRUNC(SYSDATE) AND Arrived = 'N' AND Destination = ? /* The … FlightSchedule WHERE TRUNC(ExpectedTime) = TRUNC(SYSDATE) AND Arrived = 'N' AND Destination

Deployment and Performance Guide, 10g Release 1 (10.1)

A Services Deployment Example

Step 2. Add Job Classes=> 'P3 batch'); REM Verify the job class to service configuration col service format a30 trunc select





Was this page helpful?

Integrated Cloud Applications & Platform Services