Error While Loading the data set to MY SQL Workbench

[raoreema710]

Hello @datawithdanny ,
I am currently facing an issue while running SQL script on SQL workbench. The issue occurs when I am trying to load the data in the transaction table. It says there is an incorrect date-time value for id 774.

Please let me know what can be done in this case.

[datawithdanny]

Hey @raoreema710 - I'm sorry for the delay on this one!

I'll take a look at this sometime this week when I've got a spare moment and hopefully find a fix!

[fortunewalla]

Hello @datawithdanny , I am currently facing an issue while running SQL script on SQL workbench. The issue occurs when I am trying to load the data in the transaction table. It says there is an incorrect date-time value for id 774.

Please let me know what can be done in this case.

Did you manage to solve this?

I used the MySQL init script and it created all tables without any errors.

mysql> select * from transactions where txn_id=774;
+--------+-----------+--------+------------+---------------------+----------+----------+----------------+
| txn_id | member_id | ticker | txn_date   | txn_time            | txn_type | quantity | percentage_fee |
+--------+-----------+--------+------------+---------------------+----------+----------+----------------+
|    774 | c51ce4    | BTC    | 2017-03-12 | 2017-03-12 02:52:12 | BUY      | 0.679963 |           0.11 |
+--------+-----------+--------+------------+---------------------+----------+----------+----------------+
1 row in set (0.03 sec)

[RNATH8032]

Hello @datawithdanny , I am currently facing an issue while running SQL script on SQL workbench. The issue occurs when I am trying to load the data in the transaction table. It says there is an incorrect date-time value for id 774.

Please let me know what can be done in this case.

were you able to get around this?