Beispiel #1
0
    def test_convert_dttm(self):
        dttm = self.get_dttm()

        self.assertEqual(
            OracleEngineSpec.convert_dttm("DATE", dttm),
            "TO_DATE('2019-01-02', 'YYYY-MM-DD')",
        )

        self.assertEqual(
            OracleEngineSpec.convert_dttm("TIMESTAMP", dttm),
            """TO_TIMESTAMP('2019-01-02T03:04:05.678900', 'YYYY-MM-DD"T"HH24:MI:SS.ff6')""",
        )
Beispiel #2
0
def test_convert_dttm(date_format, expected):
    dttm = TestOracleDbEngineSpec.get_dttm()
    assert OracleEngineSpec.convert_dttm(date_format, dttm) == expected