1 files changed, 22 insertions, 0 deletions
diff --git a/python/experiments/test_timestamptz.py b/python/experiments/test_timestamptz.py
new file mode 100644
index 00000000..eae44af3
--- /dev/null
+++ b/python/experiments/test_timestamptz.py
@@ -0,0 +1,22 @@
+import pandas as pd
+from db import dbengine
+engine = dbengine('serenitasdb')
+
+df1 = pd.read_sql_query("SELECT date FROM test", engine)
+
+df2 = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
+                        engine)
+df2bis = pd.read_sql_query("SELECT date FROM test WHERE date<='2014-10-17'",
+                           engine, parse_dates=['date'])
+df3 = pd.read_sql_query("SELECT date FROM test", engine,
+                        parse_dates=['date'])
+
+
+# df4 = pd.read_sql_query("SELECT date FROM index_quotes " \
+#                         "WHERE date BETWEEN '2016-10-01' AND '2016-11-30'", engine,
+#                         index_col='date')
+
+
+# CREATE TABLE test(date timestamptz);
+
+# INSERT INTO test VALUES('2014-10-16 07:50:49-04'),('2014-11-06 07:42:06-05')