diff options
Diffstat (limited to 'sqlglot/executor')
-rw-r--r-- | sqlglot/executor/env.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sqlglot/executor/env.py b/sqlglot/executor/env.py index ba9cbbd..8f64cce 100644 --- a/sqlglot/executor/env.py +++ b/sqlglot/executor/env.py @@ -173,4 +173,11 @@ ENV = { "SUBSTRING": substring, "TIMESTRTOTIME": null_if_any(lambda arg: datetime.datetime.fromisoformat(arg)), "UPPER": null_if_any(lambda arg: arg.upper()), + "YEAR": null_if_any(lambda arg: arg.year), + "MONTH": null_if_any(lambda arg: arg.month), + "DAY": null_if_any(lambda arg: arg.day), + "CURRENTDATETIME": datetime.datetime.now, + "CURRENTTIMESTAMP": datetime.datetime.now, + "CURRENTTIME": datetime.datetime.now, + "CURRENTDATE": datetime.date.today, } |