Database Reference
In-Depth Information
Example 25:
The following examples illustrate how the date functions may be used:
To change the default format for system, you can use the
Alter-Session
statement,
and change the pseudo column
nls_date_format
as in the following example:
12.8.3 Data Conversion Functions
Data conversion functions are used to convert data in the following ways:
•
Character to number
•
Number to character
•
Character to date
•
Date to character
Figure
12-9
indicates the three common data conversion functions (other less
common functions are not discussed in this course). Figure
12-10
shows date formats and
numeric formats which are often used with these functions.
Figure 12-9.
SQL Commonly Used Data Conversion Functions