ENH: Enable automatic writing of dates to Stata files
- [x] closes #12259
- [x] tests added / passed
- [x] passes `git diff upstream/master | flake8 --diff`
- [x] whatsnew entry

Automatically select type %tc for datetime[ns] columns
Change ValueErrors to NotImplementedError for unsupported types
Add tests for select exceptions

closes #12259

## [Current coverage](https://codecov.io/gh/pydata/pandas/pull/13710?src=pr) is **84.53%**

> No coverage report found for **master** at 1ce8f8e.
> 
> Powered by [Codecov](https://codecov.io?src=pr). Last updated by [1ce8f8e...73f6565](https://codecov.io/gh/pydata/pandas/compare/1ce8f8e0b8540252dac25497f29d4de66a8bea3f...73f6565d0584f8ffc5785377f5bb334269a247a3?src=pr)
 thanks!
