Results for ADD_MONTHS


1 to 15 of 15 results.


DML Reference, 10g Release 1 (10.1)

ADD_MONTHS

ADD_MONTHSThe ADD_MONTHS function returns the date that is n months after the specified date.

SQL Reference, 10g Release 1 (10.1)

ADD_MONTHS

ADD_MONTHSSyntax add_months::= Description of the illustration add_months.gif Purpose ADD_MONTHS returns the … sample table employees: SELECT TO_CHAR( ADD_MONTHS(hire_date,1), 'DD-MON-YYYY') "Next month" FROM

DML Reference, 10g Release 1 (10.1)

ADD_MONTHS

Return Value DATETIME Syntax ADD_MONTHS( start_datetime ,  n ) Arguments start_datetimeA DATETIME expression that identifies the starting date.

DML Reference, 10g Release 1 (10.1)

ADD_MONTHS

ndisplays the date of the day that is one month after January 30, 2000. SHOW ADD_MONTHS('30Jan00', 1) Since … February 29 was the last day of February 2000, ADD_MONTHS returns February 29, 2000. 29-Feb-00

DML Reference, 10g Release 1 (10.1)

6 $AGGMAP to AGGMAP

6 $AGGMAP to AGGMAP$ALLOCMAP $COUNTVAR $NATRIGGER $STORETRIGGERVAL $VARCACHE ABS ACQUIRE ACROSS ADD_MONTHS AGGMAP

SQL Reference, 10g Release 1 (10.1)

LAST_DAY

LAST_DAY, TO_CHAR( ADD_MONTHS(LAST_DAY(hire_date), 5)) "Eval Date" FROM employees; LAST_NAME HIRE_DATE Eval

Globalization Support Guide, 10g Release 1 (10.1)

4 Datetime Datatypes and Time Zone Support

Function DescriptionTable 4-1 Datetime Functions Designed for the DATE Datatype Function Description ADD_MONTHS Retur

DML Reference, 10g Release 1 (10.1)

B.1 Statements Added

B.1 Statements Added) $AGGREGATE_FROMVAR (10.1.0.0) $ALLOCMAP (10.1.0.0) $COUNTVAR (10.1.0.0) ACQUIRE (10.1.0.0) ADD_MONTHS

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Single-Row Functionsdatatype ( ADD_MONTHS, CURRENT_DATE, LAST_DAY, NEW_TIME, and NEXT_DAY ). If you provide a timestamp … interval) and to return a value of one of these types. The datetime functions are: ADD_MONTHS CURRENT_DATE

User's Guide and Reference, 10g Release 1 (10.1)

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsTO_MULTI_BYTE TO_NCHAR TO_NCLOB TO_NUMBER TO_SINGLE_BYTE ADD_MONTHS CURRENT_DATE CURRENT_TIME

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

2 Selecting a Datatype

Time Formatinclude: ADD_MONTHS SYSDATE SYSTIMESTAMP TRUNC. When applied to a DATE value, it trims off the time

DML Reference, 10g Release 1 (10.1)

A.6 Date and Time Functions

A.6 Date and Time Functionsand Time Functions Statement Description ADD_MONTHS Returns the date that is the specified number

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL Functions) ACOS ACOS(n) ADD_MONTHS ADD_MONTHS(date, integer) analytic_function analytic_function([ arguments

SQL Reference, 10g Release 1 (10.1)

Contents

ContentsACOS ADD_MONTHS ASCII ASCIISTR ASIN ATAN ATAN2 AVG BFILENAME BIN_TO_NUM BITAND CARDINALITY CAST CEIL

DML Reference, 10g Release 1 (10.1)

Contents

Contents$STORETRIGGERVAL $VARCACHE ABS ACQUIRE ACROSS ADD_MONTHS AGGMAP AGGINDEX BREAKOUT DIMENSION CACHE DIMENSION


Was this page helpful?