diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/quote_parsing/parse_emails.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/python/quote_parsing/parse_emails.py b/python/quote_parsing/parse_emails.py index c0ec0d71..f80e200e 100644 --- a/python/quote_parsing/parse_emails.py +++ b/python/quote_parsing/parse_emails.py @@ -681,6 +681,7 @@ def write_todb(swaption_stack, index_data, conn): ) sql_str = gen_sql_str(query, "swaption_ref_quotes", index_data.columns) query = sql.SQL("INSERT INTO {}({}) VALUES({}) " "ON CONFLICT DO NOTHING") + index_data["expiry"] = pd.to_datetime(index_data.expiry) with conn.cursor() as c: for t in index_data.itertuples(index=False): c.execute(sql_str, t) |