Calculate age - Revision history

Unknown user at 06:01, 10 February 2022

2022-02-10T06:01:44Z

← Older revision		Revision as of 14:01, 10 February 2022
Line 26:		Line 26:
	<references />		<references />

	[[Category:Excel]] [[Category:MySQL]]		[[Category:Excel]] [[Category:MySQL]] [[Category:Time river]]

Unknown user at 06:00, 10 February 2022

2022-02-10T06:00:20Z

← Older revision		Revision as of 14:00, 10 February 2022
Line 1:		Line 1:
	Calculate age in Excel or MySQL		Calculate age in Excel or MySQL

	== In Excel ==		== Calculate age in Excel ==
	If the column value is well-formatted		If the column value is well-formatted

Line 7:		Line 7:
	* {{kbd \| key=<nowiki>=ROUNDDOWN(YEARFRAC(BIRTH_DAY, TODAY(), 1), 0)</nowiki>}}		* {{kbd \| key=<nowiki>=ROUNDDOWN(YEARFRAC(BIRTH_DAY, TODAY(), 1), 0)</nowiki>}}

	== In MySQL ==		== Calculate age in MySQL ==

	<pre>		<pre>
Line 16:		Line 16:

	<ref>[https://stackoverflow.com/questions/5773405/calculate-age-in-mysql-innodb sql - Calculate Age in MySQL (InnoDb) - Stack Overflow]</ref>		<ref>[https://stackoverflow.com/questions/5773405/calculate-age-in-mysql-innodb sql - Calculate Age in MySQL (InnoDb) - Stack Overflow]</ref>

			== Challenge of real world data ==
			The column value is '''NOT''' well-formatted such as

			* year only e.g. {{CURRENTYEAR}}
			* month & date only e.g. {{CURRENTMONTH}}-{{CURRENTDAY}}

	== References ==		== References ==

Unknown user: Created page with "Calculate age in Excel or MySQL == In Excel == If the column value is well-formatted * {{kbd | key==(TODAY()- BIRTH_DAY)/365}}[https://www.ablebits.com..."

2022-02-10T05:55:51Z

Created page with "Calculate age in Excel or MySQL == In Excel == If the column value is well-formatted * {{kbd | key=<nowiki>=(TODAY()- BIRTH_DAY)/365</nowiki>}}<ref>[https://www.ablebits.com..."

New page

Calculate age in Excel or MySQL

== In Excel ==
If the column value is well-formatted

* {{kbd | key=<nowiki>=(TODAY()- BIRTH_DAY)/365</nowiki>}}<ref>[https://www.ablebits.com/office-addins-blog/2016/10/19/calculate-age-excel/ How to calculate age in Excel from birthday]</ref>
* {{kbd | key=<nowiki>=ROUNDDOWN(YEARFRAC(BIRTH_DAY, TODAY(), 1), 0)</nowiki>}}

== In MySQL ==

<pre>
SELECT `birth_date`, TIMESTAMPDIFF (YEAR, `birth_date`, CURDATE()) AS age
FROM `my_table`
WHERE `birth_date` IS NOT NULL
</pre>

<ref>[https://stackoverflow.com/questions/5773405/calculate-age-in-mysql-innodb sql - Calculate Age in MySQL (InnoDb) - Stack Overflow]</ref>

== References ==
<references />

[[Category:Excel]] [[Category:MySQL]]