diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-03-12 10:17:16 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-03-12 10:17:16 +0000 |
| commit | 7457677bc603569692329e39a59ccb018306e2a6 (patch) | |
| tree | bb16c8f909bfbf7ff272cd8ef14a413c47b203fe /tests/dialects/test_sqlite.py | |
| parent | Releasing debian version 11.3.3-1. (diff) | |
| download | sqlglot-7457677bc603569692329e39a59ccb018306e2a6.tar.xz sqlglot-7457677bc603569692329e39a59ccb018306e2a6.zip | |
Merging upstream version 11.3.6.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_sqlite.py')
| -rw-r--r-- | tests/dialects/test_sqlite.py | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/tests/dialects/test_sqlite.py b/tests/dialects/test_sqlite.py index a3e4cc9..f889445 100644 --- a/tests/dialects/test_sqlite.py +++ b/tests/dialects/test_sqlite.py @@ -89,6 +89,20 @@ class TestSQLite(Validator): write={"snowflake": "LEAST(x, y, z)"}, ) + def test_datediff(self): + self.validate_all( + "DATEDIFF(a, b, 'day')", + write={"sqlite": "CAST((JULIANDAY(a) - JULIANDAY(b)) AS INTEGER)"}, + ) + self.validate_all( + "DATEDIFF(a, b, 'hour')", + write={"sqlite": "CAST((JULIANDAY(a) - JULIANDAY(b)) * 24.0 AS INTEGER)"}, + ) + self.validate_all( + "DATEDIFF(a, b, 'year')", + write={"sqlite": "CAST((JULIANDAY(a) - JULIANDAY(b)) / 365.0 AS INTEGER)"}, + ) + def test_hexadecimal_literal(self): self.validate_all( "SELECT 0XCC", |