Look at the example and query the next year'2xxx', for example this year 2014, the result is 2015
|
1
|
select
substr(
char
(
current
timestamp
),1,4)+1
from
SYSIBM.SYSDUMMY1;
|
substr(String, intercept start position, intercept length) //Return the intercepted string
instr(source string, string to be found, starting from the first character, finding the matching number)//Return to the location found, if not found, return 0
Examples to use together:
|
1
2
3
4
5
6
|
select
'aa|bb|cc|dd|'
all
,
substr(
'aa|bb|cc|dd|'
,1,instr(
'aa|bb|cc|dd|'
,
'|'
,1,1)-1) aa,
substr(
'aa|bb|cc|dd|'
,instr(
'aa|bb|cc|dd|'
,
'|'
,1,1)+1,instr(
'aa|bb|cc|dd|'
,
'|'
,1,2)-instr(
'aa|bb|cc|dd|'
,
'|'
,1,1)-1) bb,
substr(
'aa|bb|cc|dd|'
,instr(
'aa|bb|cc|dd|'
,
'|'
,1,2)+1,instr(
'aa|bb|cc|dd|'
,
'|'
,1,3)-instr(
'aa|bb|cc|dd|'
,
'|'
,1,2)-1) cc,
substr(
'aa|bb|cc|dd|'
,instr(
'aa|bb|cc|dd|'
,
'|'
,1,3)+1,instr(
'aa|bb|cc|dd|'
,
'|'
,1,4)-instr(
'aa|bb|cc|dd|'
,
'|'
,1,3)-1) dd
from
sysibm.sysdummy1；
|
The result is returned as follows:
| ALL | AA | BB | CC | DD |
|---|---|---|---|---|
| aa|bb|cc|dd| | aa | bb | cc | dd |
Note: The substr and instr functions are also applicable to oracle, and the syntax and usage methods are consistent.
Reprinted from: /senyier/p/