diff options
Diffstat (limited to '')
-rw-r--r-- | sqlglot/dialects/teradata.py | 24 |
1 files changed, 16 insertions, 8 deletions
diff --git a/sqlglot/dialects/teradata.py b/sqlglot/dialects/teradata.py index 141d9c0..0ccc567 100644 --- a/sqlglot/dialects/teradata.py +++ b/sqlglot/dialects/teradata.py @@ -12,22 +12,30 @@ class Teradata(Dialect): TYPED_DIVISION = True TIME_MAPPING = { - "Y": "%Y", - "YYYY": "%Y", "YY": "%y", - "MMMM": "%B", + "Y4": "%Y", + "YYYY": "%Y", + "M4": "%B", + "M3": "%b", + "M": "%-M", + "MI": "%M", + "MM": "%m", "MMM": "%b", - "DD": "%d", + "MMMM": "%B", "D": "%-d", - "HH": "%H", + "DD": "%d", + "D3": "%j", + "DDD": "%j", "H": "%-H", - "MM": "%M", - "M": "%-M", - "SS": "%S", + "HH": "%H", + "HH24": "%H", "S": "%-S", + "SS": "%S", "SSSSSS": "%f", "E": "%a", "EE": "%a", + "E3": "%a", + "E4": "%A", "EEE": "%a", "EEEE": "%A", } |