Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→Time data: Verify the data format
| Line 291: | Line 291: | ||
=== Time data: Verify the data format === | === Time data: Verify the data format === | ||
Verify the value by using MySQL functions: | |||
Verify the value should be year-month-day format e.g. {{Template:Today}} | Verify the value should be year-month-day format e.g. {{Template:Today}} | ||
| Line 327: | Line 328: | ||
</pre> | </pre> | ||
Alternative PHP solution: [https://www.php.net/manual/en/function.strtotime.php strtotime] | |||
=== Time data: Data was generated in 10 years === | === Time data: Data was generated in 10 years === | ||