odo can not read back datetime column from sqlite generated by itself
Open
- Dominant language
- Python
- Stars
- 1k
- Forks
- 131
- PR merge metrics
- No merged PRs in 30d
Description
given a simple foo.csv like:
```
,colA,colB
0,1,2015-12-25
1,3,
2,3,
3,2,2015-12-28
4,3,
```
convert it into a sqlite db:
```
>>> odo('foo.csv', 'sqlite:///foo_1::foo')
Table('foo', MetaData(bind=Engine(sqlite:///foo_1)), Column('Unnamed: 0', BigInteger(), table=, nullable=False), Column('A', BigInteger(), table=, nullable=False), Column('B', DateTime(), table=), schema=None)
```
but now odo can not read it back:
```
df1 = odo('sqlite:///foo_1::foo', pd.DataFrame)
```
gives error:
ValueError: Couldn't parse datetime string: u'2015-12-25'
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.