embulk / embulk/embulk-input-jdbc
【MYSQL】date issue with 0001-01-01
- Dominant language
- Java
- Stars
- 106
- Forks
- 76
- PR merge metrics
- No merged PRs in 30d
Description
I create one table and test.yaml to try using embulk run.
|id|date|datetime|
|:---|:---|:---|
|1|0001-01-01|0001-01-01 00:00:00|
```
in:
type: mysql
host: localhost
user: user
password: password
database: db
query: |
SELECT date,datetime FROM one WHERE id = 1
out:
type: stdout
```
Then, use embulk run
```
$ embulk run test.yml
```
Result
```
0000-12-29,0000-12-30 00:00:00
````
I think result is not correct. Do you have any solution or idea ?
I would not like to use column_options if possible.
```
column_options:
date: {type: string, value_type: string}
datetime: {type: string, value_type: string}
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.