[Python] Can't convert datetime.date to pa.timestamp in pa.array

### Describe the bug, including details regarding any error messages, version, and platform.

Array does not allow this conversion, but Table does.

```
>>> import pyarrow as pa
>>> import datetime

>>> pa.table([pa.array([datetime.date(2000, 1, 1)])], schema=pa.schema([pa.field('date', pa.timestamp('s'))]))
pyarrow.Table
date: timestamp[s]
----
date: [[2000-01-01 00:00:00]]

>>> pa.array([datetime.date(2000, 1, 1)], type=pa.timestamp('s'))
Traceback (most recent call last):
File "", line 1, in
File "pyarrow/array.pxi", line 327, in pyarrow.lib.array
result = _sequence_to_array(obj, mask, size, type, pool, c_from_pandas)
File "pyarrow/array.pxi", line 39, in pyarrow.lib._sequence_to_array
chunked = GetResultValue(
File "pyarrow/error.pxi", line 144, in pyarrow.lib.pyarrow_internal_check_status
return check_status(status)
File "pyarrow/error.pxi", line 123, in pyarrow.lib.check_status
raise ArrowTypeError(message)
pyarrow.lib.ArrowTypeError: object of type cannot be converted to int
```

### Component(s)

Python