get only date from datetime in mysql php code example Example: only date in php date('Y:m:d', strtotime($date))