BUG: to_sql fails with datetime.time values with sqlite fallback mode

[jorisvandenbossche]

Columns of datetime.time were not yet supported in sqlite fallback mode (as noted in #7567, and do work for sqlalchemy), but it now seems to fail silently with master (instead of raising an error).

Using:

import sqlite3
con = sqlite3.connect(':memory:')
dt = pd.date_range('2014-01-01', periods=10, freq='10h')
df = pd.DataFrame({'date':dt.date, 'time':dt.time})
df.to_sql('test_datetime', con, index=False, if_exists='replace')

gives:

In [37]: pd.read_sql_query('select * from test_datetime', con)
Out[37]: 
Empty DataFrame
Columns: [date, time]
Index: []

[jreback]

@jorisvandenbossche pls move any sql issues you don't think can get to in next couple of days to 0.15.1 pls.

[jreback]

push?

[jorisvandenbossche]

@jreback I will have a look at the sql issues this evening and push if necessary

[jreback]

@jorisvandenbossche gr8 thanks

[jorisvandenbossche]

I will try to look at it this weekend

[jorisvandenbossche]

See #8470 to fix the fact it fails silently. So now it will again just raise a InterfaceError: Error binding parameter 0 - probably unsupported type.
Changed title of issue to reflect that.

[jorisvandenbossche]

We could provide an adapter:https://docs.python.org/2/library/sqlite3.html#registering-an-adapter-callable

[jorisvandenbossche]

Closed by #11547