For more information:
- To learn more about the DATE_FORMAT built-in function, visit https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format.
- To learn more about the TIME_FORMAT built-in function, visit https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_time-format.
- To learn more the ADDDATE built-in function INTERVALS, visit https://dev.mysql.com/doc/refman/8.0/en/expressions.html#temporal-intervals.
- To learn more about variance and standard deviation, visit https://www.khanacademy.org/math/probability/data-distributions-a1/summarizing-spread-distributions/v/range-variance-and-standard-deviation-as-measures-of-dispersion.
- To learn more about the Oracle EXTRACT function, visit https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm.
- To learn more about the PostgreSQL EXTRACT function, visit https://www.postgresql.org/docs/11/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT.
- To learn more about converting dates into specific formats in SQL Server, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15#date-and-time-styles.
- To learn more about the DATEPART function in SQL Server, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/datepart-transact-sql?view=sql-server-ver15.
- To learn more about the DATENAME function in SQL Server, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/datename-transact-sql?view=sql-server-ver15.
- To learn more about the DATEADD function in SQL Server, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver15.
- To learn more about the DATEDIFF function in SQL Server, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/datediff-transact-sql?view=sql-server-ver15.
- To learn more about the Oracle sys_context function, visit https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions165.htm.
- To learn more about the Oracle CAST function, visit https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions016.htm.
- To learn more about the Oracle CONVERT function, visit https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions027.htm#SQLRF00620.
- To learn more about the Oracle IF function, visit https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/if_statement.htm.
- To learn more about the PostgreSQL data type formatting functions, visit, https://www.postgresql.org/docs/11/functions-formatting.html.
- To learn more about the PostgreSQL IF function, visit https://www.postgresql.org/docs/9.1/plpgsql-control-structures.html.
- To learn more about the SQL Server CAST and CONVERT functions, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15#date-and-time-styles.
- To learn more about the SQL Server IF function, visit https://docs.microsoft.com/en-us/sql/t-sql/language-elements/if-else-transact-sql?view=sql-server-ver15.
- To learn more about the SQL Server ISNULL function, visit https://docs.microsoft.com/en-us/sql/t-sql/functions/isnull-transact-sql?view=sql-server-ver15.