Oracle conversion function

xiaoxiao2021-03-06  70

Date conversion function

Add_MONTHS (D, N)

N is the multiple of the month: for example D = 20041116 add_months (to_date (d, 'YYYYMMDD', 1) result is 20041216

2. Digital conversion function

TO_NUMBER (C, '999, 999')

Conversion string is Number type

For example: c = '158,000' TO_NUMBER (C, '999, 999') = 158000

转载请注明原文地址:https://www.9cbs.com/read-91575.html

New Post(0)