Filter
Top Products
6.6 Converting the Data Type to Manipulate Data
The data types of columns can be converted to execute date or time operations using character strings and to add or
update data in time type or time interval type columns.
An example of a date operation executed by converting the character string data type to the time interval type (year
and month) is given below.
Example 1:
In this example, codes and dates obtained by adding six months to the process date are fetched from
the OFFICE table. Also, "6" has been specified for character string type host variable CDATE.
117