Using STR(), INT(), FLOAT(), and DATE() for explicit type conversion — which function to apply when a date stored as integer (YYYYMMDD) must be converted to a date type.