search

kayak / pypika

PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
http://pypika.readthedocs.io/en/latest/
Apache License 2.0
2.43k stars 292 forks source link

Add MONTH and DAYOFMONTH sql functions #807

Open abhishakegupta91 opened 2 weeks ago

abhishakegupta91 commented 2 weeks ago

This commit adds 2 sql functions that are used widely on date columns in a table.

MONTH -> returns the Month of the datefield DAYOFMONTH -> returns the Day of the month in datefield.