DDC-1014: Evaluate common date related functions for DQL inclusion #1266

New Issue

admin · 2026-01-22T13:07:44+01:00

admin commented

2026-01-22 13:07:44 +01:00

Originally created by @doctrinebot on GitHub (Feb 2, 2011).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

To check:

Difference in days between two dates
Add/subtract an interval to a date
Format a date
Return only Year, Month or Day, Day of Week, Week of Year of the date

Originally created by @doctrinebot on GitHub (Feb 2, 2011). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: To check: - Difference in days between two dates - Add/subtract an interval to a date - Format a date - Return only Year, Month or Day, Day of Week, Week of Year of the date

admin added the Improvement label 2026-01-22 13:07:44 +01:00

admin closed this issue

2026-01-22 13:07:44 +01:00

admin commented

2026-01-22 13:07:46 +01:00

@doctrinebot commented on GitHub (Mar 27, 2011):

Comment created by @beberlei:

MySQL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

DATEDIFF, DATE_ADD, DATE_SUB, DATE_FORMAT, YEAR, MONTH, DAY, WEEK, DATE

Postgres: http://developer.postgresql.org/pgdocs/postgres/functions-datetime.html

DATEDIFF, DATE_ADD/SUB (Operator), Kein Format?, YEAR, MONTH, DAY, WEEK

Sqlite: http://www.sqlite.org/lang_datefunc.html

Operators, date(), format, YEAR, MONTH, DAY, WEEK,DATE

Oracle: http://www.oracle-dba-online.com/sql/dateoperators_functions.htm http://www.akadia.com/services/ora_datetime.html

Operators, TO_CHAR()/EXTRACT()

MSSQL: http://msdn.microsoft.com/en-us/library/aa258863%28v=sql.80%29.aspx

@doctrinebot commented on GitHub (Mar 27, 2011): Comment created by @beberlei: MySQL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html DATEDIFF, DATE_ADD, DATE_SUB, DATE_FORMAT, YEAR, MONTH, DAY, WEEK, DATE Postgres: http://developer.postgresql.org/pgdocs/postgres/functions-datetime.html DATEDIFF, DATE_ADD/SUB (Operator), Kein Format?, YEAR, MONTH, DAY, WEEK Sqlite: http://www.sqlite.org/lang_datefunc.html Operators, date(), format, YEAR, MONTH, DAY, WEEK,DATE Oracle: http://www.oracle-dba-online.com/sql/date*operators_functions.htm http://www.akadia.com/services/ora_date*time.html Operators, TO_CHAR()/EXTRACT() MSSQL: http://msdn.microsoft.com/en-us/library/aa258863%28v=sql.80%29.aspx

admin commented

2026-01-22 13:07:46 +01:00

@doctrinebot commented on GitHub (Mar 27, 2011):

Comment created by @beberlei:

Implemented

@doctrinebot commented on GitHub (Mar 27, 2011): Comment created by @beberlei: Implemented

admin commented

2026-01-22 13:07:46 +01:00

@doctrinebot commented on GitHub (Mar 27, 2011):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Mar 27, 2011): Issue was closed with resolution "Fixed"

admin referenced this issue