Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[function] last_day #19548

Closed
wangsimo0 opened this issue Mar 15, 2023 · 1 comment · Fixed by #23348
Closed

[function] last_day #19548

wangsimo0 opened this issue Mar 15, 2023 · 1 comment · Fixed by #23348
Assignees

Comments

@wangsimo0
Copy link
Contributor

Feature request

as mentioned in #15385, last_day need to be supported. However last day can be used in month/quarter/year. So I think it's better to support this feature flexibly.

here is my proposal:

description

Returns the last day of the specified date part for a date or datetime.

syntax

LAST_DAY ( <date_or_datetime_expr> , [<date_part>])

in which,
date_or_datetime_expr is a date or datetime expression
date_part is an optional parameter. can be month, quarter,year, default to month.
the return value is always a date.

@vendanner
Copy link
Contributor

here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants