def test_convert_dttm(self): dttm = self.get_dttm() self.assertEqual( PostgresEngineSpec.convert_dttm("DATE", dttm), "TO_DATE('2019-01-02', 'YYYY-MM-DD')", ) self.assertEqual( PostgresEngineSpec.convert_dttm("TIMESTAMP", dttm), "TO_TIMESTAMP('2019-01-02 03:04:05.678900', 'YYYY-MM-DD HH24:MI:SS.US')", )
def test_convert_dttm(self): """ DB Eng Specs (postgres): Test conversion to date time """ dttm = self.get_dttm() self.assertEqual( PostgresEngineSpec.convert_dttm("DATE", dttm), "TO_DATE('2019-01-02', 'YYYY-MM-DD')", ) self.assertEqual( PostgresEngineSpec.convert_dttm("TIMESTAMP", dttm), "TO_TIMESTAMP('2019-01-02 03:04:05.678900', 'YYYY-MM-DD HH24:MI:SS.US')", ) self.assertEqual(PostgresEngineSpec.convert_dttm("DATETIME", dttm), None)