2024年4月28日发(作者：)

函数类型oracle函数

to_date(string,format)

sysdate

add_months(date,number)

sysdate+n

last_day(date)

Gbase函数

to_date(string,format)

sysdate()或者now()

add_months(date,number)

adddate(sysdate(),n)

last_day()

日期函数

month_between(date,date)timestampdiff(month,date,date)

trunc

trunc(sysdate,'day')

ascii(str)

to_char()

substr()

instr(str,substr)

nvl

case when

trim(str)

ltrim(str)

rtrim(str)

to_number()

rowid

replace(str,from_str,to_

str)

concat()

repeat(str,count)

lower(str)

upper(str)

length(str)

lengthb(str)

abs(n)

ceil(n)

floor(n)

mod(m,n)

trunc

round

sum

count

avg

max

min

vm_concat,listagg

rank()over

dense_rank()over

row_number()over

sum()over

avg()over

count()over

max()over

min()over

lead()over

lag()over

trunc

adddate(curdate(),-

weekday(curdate()))

ascii(str)

to_char()

substr()

instr(str,substr)

nvl

case when

trim(str)

ltrim(str)

rtrim(str)

to_number()

replace(str,from_str,to_str)

concat()

repeat(str,count)

lower(str)

upper(str)

length(str)

不支持

abs(n)

ceil(n)

floor(n)

mod(m,n)

truncate

round

sum

count

avg

max

min

group_concat

rank()over

dense_rank()over

row_number()over

sum()over

avg()over

count()over

max()over

min()over

lead()over

lag()over

字符函数

数值函数

聚集函数

分析函数

group by cube

group by rollup

group by grouping set

两个日期之间的间隔

group by cube

group by rollup

group by grouping set

timestampdiff