mysql 集函数_Mysql 常用函数集

adddate(date,interval expr type)

adddate(expr,days)

addtime(expr,expr2)

convert_tz(dt,from_tz,to_tz)

curdate()current_date()current_time()current_timestamp()

curtime()

date(expr)datediff(expr,expr2)

date_add(date,interval expr type)

date_format(date,format)

date_add(date,interval expr type)day(date)

dayname(date)

dayofweek(date)

dayofyear(date)

extract(typefromdate)

dayofmonth(date)

from_days(n)

from_unixtime(unix_timestamp)

from_unixtime(unix_timestamp,format)

get_format(date|time|datetime, 'eur'|'usa'|'jis'|'iso'|'internal')

hour(time)

last_day(date)

ln(x)

localtime()

localtimestamp()log(x) log(b,x)

makedate(year,dayofyear)

maketime(hour,minute,second)

microsecond(expr)

minute(time)month(date)

monthname(date)

now()

period_add(p,n)

period_diff(p1,p2)

quarter(date)

second(time)

sec_to_time(seconds)

str_to_date(str,format)

subdate(date,interval expr type) subdate(expr,days)

subtime(expr,expr2)

sysdate()

time(expr)

timediff(expr,expr2)

timestampadd(interval,int_expr,datetime_expr)

timestampdiff(interval,datetime_expr1,datetime_expr2)

time_format(time,format)

time_to_sec(time)

to_days(date)truncate(x,d)

unix_timestamp()

unix_timestamp(date)

utc_date()

utc_time()

utc_timestamp()

week(date[,mode])

weekday(date)

weekofyear(date)year(date)

yearweek(date)

yearweek(date,start)