Home > Database > Mysql Tutorial > mysql计算生日算法_MySQL

mysql计算生日算法_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-01 13:29:19
Original
1447 people have browsed it

bitsCN.com

mysql计算生日算法

 

1year( from_days( datediff( now( ), birthdate)))now() 当前时间,精确到秒datediff(begindate,enddate):返回两日期之间相关的日数.from_days(days):从0000-00-00开始,根据传入的日数,返回一个日期;year(date):获取日期上的年.
Copy after login

 


bitsCN.com
Related labels:
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template