/ 
SQL-Statement-Functions-Date-0.050
River stage zero No dependents
++

Changes for version 0.050 - 2022-12-12

  • Add functions: HOUR, MINUTE, SECOND, DATE, TIME.
  • Tweak Abstracts.

Modules

SQL::Statement::Function::ByName::DATE
Return the date part (e.g. 2022-12-13) of a date/datetime expression
SQL::Statement::Function::ByName::DAY
Synonym for DAYOFMONTH() SQL function
SQL::Statement::Function::ByName::DAYOFMONTH
Return day of month of a date/datetime expression
SQL::Statement::Function::ByName::DAYOFYEAR
Return day of year of a date/datetime expression
SQL::Statement::Function::ByName::HOUR
Return the hour part (00-23) of a date/datetime expression
SQL::Statement::Function::ByName::ISO_YEARWEEK
Return ISO 8601 YYYY-"W"ww (e.g. 2022-W51) of a date/datetime expression
SQL::Statement::Function::ByName::MINUTE
Return the minute part (00-59) of a date/datetime expression
SQL::Statement::Function::ByName::MONTH
Return the month part of a date/datetime expression
SQL::Statement::Function::ByName::SECOND
Return the second part (00-60) of a date/datetime expression
SQL::Statement::Function::ByName::TIME
Return the time part (e.g. 13:56:57) of a date/datetime expression
SQL::Statement::Function::ByName::WEEKDAY
WEEKDAY() SQL function
SQL::Statement::Function::ByName::WEEKOFYEAR
Return week of the year from a date/datetime expression
SQL::Statement::Function::ByName::YEAR
Return the year part from a date/datetime expression
SQL::Statement::Functions::Date
More date/time functions

Other files