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.

Sign up for GitHub

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

Jump to bottom

Add date function to get current date without time component #1936

Closed
paulrutter opened this issue Jun 18, 2024 · 4 comments
Closed

Add date function to get current date without time component #1936

paulrutter opened this issue Jun 18, 2024 · 4 comments

Comments

@paulrutter
Copy link
Contributor

paulrutter commented Jun 18, 2024 •
edited
Loading

Please introduce a function to get the current date without time component, so this is no longer needed:

DATE(YEAR(NOW()) + '-' + MONTH(NOW()) + '-' + DAY(NOW()))

See https://www.w3schools.com/sql/func_mysql_curdate.asp for example.
paulrutter added a commit to blueconic/alasql that referenced this issue Jun 18, 2024
@paulrutter
AlaSQL#1936 Add date function to get current date without time component
7ae7564 
- Add CURDATE method to AlaSQL
- Add test
@paulrutter
Copy link
Contributor Author

#1937

@paulrutter
Copy link
Contributor Author

Naming of the function is up for debate.

@paulrutter
Copy link
Contributor Author

alasql/src/alasqlparser.jison

Line 110 in ca7ecb4

'DATEDIFF' return 'DATEDIFF'
probably needs updating as well.

paulrutter added a commit to blueconic/alasql that referenced this issue Jun 19, 2024
@paulrutter
AlaSQL#1936 Add date function to get current date without time component
9202f79 
- Support dateAsString option
- Extend tests
paulrutter added a commit to blueconic/alasql that referenced this issue Jun 19, 2024
@paulrutter
AlaSQL#1936 Add date function to get current date without time component
8576258 
- Add CURRENT_DATE alias
- Extend test
@paulrutter paulrutter mentioned this issue Jun 30, 2024
Merged
mathiasrw pushed a commit that referenced this issue Jul 8, 2024
@paulrutter
Add date function to get current date without time component (#1937)
7785563 
* #1936 Add date function to get current date without time component
- Add CURDATE method to AlaSQL
- Add test

* #1936 Add date function to get current date without time component
- Support dateAsString option
- Extend tests

* #1936 Add date function to get current date without time component
- Add CURRENT_DATE alias
- Extend test

* - Fix running the parser in package.json
- Add rebuild parser documentation
- Add CURDATE/CURRENT_DATE to parser definition
- Allow both with and without parenthesis
- Adjust test

* - Use tabs

* - Use alias to prevent duplicate code for CURRENT_DATE

* - Update dependencies
mathiasrw pushed a commit that referenced this issue Jul 8, 2024
@paulrutter @mathiasrw
Add date function to get current date without time component (#1937)
53ad87c 
* #1936 Add date function to get current date without time component
- Add CURDATE method to AlaSQL
- Add test

* #1936 Add date function to get current date without time component
- Support dateAsString option
- Extend tests

* #1936 Add date function to get current date without time component
- Add CURRENT_DATE alias
- Extend test

* - Fix running the parser in package.json
- Add rebuild parser documentation
- Add CURDATE/CURRENT_DATE to parser definition
- Allow both with and without parenthesis
- Adjust test

* - Use tabs

* - Use alias to prevent duplicate code for CURRENT_DATE

* - Update dependencies
@paulrutter
Copy link
Contributor Author

Fixed in #1937

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@paulrutter