We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
SELECT last_day_of_month(DATE'2019-08-01') --> 2019-07-31 inorrect SELECT last_day_of_month(DATE'2019-08-02') --> 2019-08-31 correct
SELECT last_day_of_month(DATE'2019-08-01')
2019-07-31
SELECT last_day_of_month(DATE'2019-08-02')
2019-08-31
SELECT last_day_of_month(TIMESTAMP'2019-07-31 23:59:59') --> 2019-07-31 correct SELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:00') --> 2019-07-31 inorrect SELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:01') --> 2019-08-31 correct
SELECT last_day_of_month(TIMESTAMP'2019-07-31 23:59:59')
SELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:00')
SELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:01')
The text was updated successfully, but these errors were encountered:
Add last_day_of_month function
2718f1a
findepi
Successfully merging a pull request may close this issue.
SELECT last_day_of_month(DATE'2019-08-01')
-->2019-07-31
inorrectSELECT last_day_of_month(DATE'2019-08-02')
-->2019-08-31
correctSELECT last_day_of_month(TIMESTAMP'2019-07-31 23:59:59')
-->2019-07-31
correctSELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:00')
-->2019-07-31
inorrectSELECT last_day_of_month(TIMESTAMP'2019-08-01 00:00:01')
-->2019-08-31
correctThe text was updated successfully, but these errors were encountered: