Skip Headers
Oracle® OLAP DML Reference
11g Release 1 (11.1)

B28126-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

TODAY

The TODAY function returns the current date as a DATE or TEXT value.

Return Value

DATE or TEXT depending on the data type that is expected:

Syntax

TODAY

Examples

Example 8-146 Displaying Today's Date

The following statements send the current date in DATE format to the current outfile.

DATEFORMAT = '<wtextl> <mtextl> <d>, <yyyy>'
SHOW TODAY

When the current date is January 15, 1996, then these statements produce the following output.

Monday January 15, 1996

Example 8-147 Calculating a Date Using the TODAY Function

The following statement calculates the date 60 days from today.

SHOW TODAY + 60

When the current date is January 15, 1996, then this statement produces the following output.

Friday March 15, 1996