14,959
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Condition: Human birth year (age) data
| Line 319: | Line 319: | ||
WHERE TIMESTAMPDIFF(YEAR, `birthday`, CURDATE()) <= 122 | WHERE TIMESTAMPDIFF(YEAR, `birthday`, CURDATE()) <= 122 | ||
</pre> | </pre> | ||
Using [https://www.w3resource.com/mysql/date-and-time-functions/mysql-unix_timestamp-function.php UNIX_TIMESTAMP() function] to check the abnormality of birthday data is not appropriate. Because the birthdays which are earlier {{kbd | key=<nowiki>1970-01-01 00:00:00 UTC</nowiki>}} will all become zero. | |||
== Duplicate data == | == Duplicate data == | ||