Operation Code Description for DB2 data type conversion

This article mainly describes the actual operation steps of DB2 data type conversion. First, we will introduce the actual operation code of DB2 data type conversion to introduce the operation steps of DB2 data type conversion, the following is a detailed description of the main content of the article. I hope you will have a better understanding of it after browsing.

DB2 data type conversion:

 
 

  
  
Money is an Integer ----> char (money)
  
  
Char -------> Integer (trim (char (money )))
  
  
Money is double (8, 2) double -----> char (cast (money as decimal (8, 2 )))
  
  
Char -------> double cast (char (cast (a. money as decimal (8, 2) as decimal (8, 2) as double)
  
  
The value of money is decimal (8, 2) decimal -------> char Digits (money)
  
  
Char -------> decimal cast (Digits (money) as decimal (8, 2 ))
  
  
Money is date ------> char (money)
  
  
Char ------> date (trim (char (money )))
  
  
Money is bigint ----> char (money)
  
  
Char -----> bigint cast (char (money) as bigint)
 
 

This is what I encountered during the project process: a trigger is used to save the deleted or modified data to an xml column. It is required for group strings. I spent one morning searching for documents and experimenting. Many introductions on the Internet are too general and not applicable. If there are any errors, please point out that if you still need to add, or if you think it is important, you can notify me, I will add. Thank you!

The above content is an introduction to DB2 data type conversion. I hope you will find some gains.