1 files changed, 28 insertions, 0 deletions
diff --git a/test/dialect/test_sybase.py b/test/dialect/test_sybase.py
new file mode 100644
index 000000000..37de91d1c
--- /dev/null
+++ b/test/dialect/test_sybase.py
@@ -0,0 +1,28 @@
+from sqlalchemy import *
+from sqlalchemy import sql
+from sqlalchemy.databases import sybase
+from sqlalchemy.test import *
+
+
+class CompileTest(TestBase, AssertsCompiledSQL):
+    __dialect__ = sybase.dialect()
+
+    def test_extract(self):
+        t = sql.table('t', sql.column('col1'))
+
+        mapping = {
+            'day': 'day',
+            'doy': 'dayofyear',
+            'dow': 'weekday',
+            'milliseconds': 'millisecond',
+            'millisecond': 'millisecond',
+            'year': 'year',
+            }
+
+        for field, subst in mapping.items():
+            self.assert_compile(
+                select([extract(field, t.c.col1)]),
+                'SELECT DATEPART("%s", t.col1) AS anon_1 FROM t' % subst)
+
+
+