def test__cast__date(self):
q1 = Q.from_(self.t).select(fn.Date(self.t.foo))
q2 = Q.from_(self.t).select(fn.Cast(self.t.foo, SqlTypes.DATE))
self.assertEqual("SELECT DATE(\"foo\") FROM \"abc\"", str(q1))
self.assertEqual("SELECT CAST(\"foo\" AS DATE) FROM \"abc\"", str(q2))
def test__cast__date(self):
q1 = Q.from_(self.t).select(fn.Date(self.t.foo))
q2 = Q.from_(self.t).select(fn.Cast(self.t.foo, SqlTypes.DATE))
self.assertEqual('SELECT DATE("foo") FROM "abc"', str(q1))
self.assertEqual('SELECT CAST("foo" AS DATE) FROM "abc"', str(q2))