|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
When you display the result returned by TODAY, the value has the format specified by the date template in the DATEFORMAT option. When the day of the week or the name of the month is used in the date template, TODAY uses the day names specified in the DAYNAMES option and the month names specified in the MONTHNAMES option. You can use the result returned by TODAY anywhere that a DATE value is expected.
You can also use the result where a text value is expected. TODAY automatically converts the date to a text value, using the current template in the DATEFORMAT option to format the text value. When you want to override the current DATEFORMAT template, you can convert the date result to text by using the CONVERT function with a date-format argument.
Example 23-26 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