diff options
Diffstat (limited to 'connectivity/source/inc/file/FDateFunctions.hxx')
| -rw-r--r-- | connectivity/source/inc/file/FDateFunctions.hxx | 398 |
1 files changed, 199 insertions, 199 deletions
diff --git a/connectivity/source/inc/file/FDateFunctions.hxx b/connectivity/source/inc/file/FDateFunctions.hxx index e8eb12d0cf24..8451eb0fbf7f 100644 --- a/connectivity/source/inc/file/FDateFunctions.hxx +++ b/connectivity/source/inc/file/FDateFunctions.hxx @@ -22,206 +22,206 @@ #include <file/fcode.hxx> namespace connectivity::file +{ + /** DAYOFWEEK(date) + Returns the weekday index for date (1 = Sunday, 2 = Monday, ... 7 = Saturday). These index values correspond to the ODBC standard. + + > SELECT DAYOFWEEK('1998-02-03'); + -> 3 + */ + class OOp_DayOfWeek : public OUnaryOperator { - /** DAYOFWEEK(date) - Returns the weekday index for date (1 = Sunday, 2 = Monday, ... 7 = Saturday). These index values correspond to the ODBC standard. - - > SELECT DAYOFWEEK('1998-02-03'); - -> 3 - */ - class OOp_DayOfWeek : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** DAYOFMONTH(date) - Returns the day of the month for date, in the range 1 to 31: - - > SELECT DAYOFMONTH('1998-02-03'); - -> 3 - */ - class OOp_DayOfMonth : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** DAYOFYEAR(date) - Returns the day of the year for date, in the range 1 to 366: - - > SELECT DAYOFYEAR('1998-02-03'); - -> 34 - - */ - class OOp_DayOfYear : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** MONTH(date) - Returns the month for date, in the range 1 to 12: - - > SELECT MONTH('1998-02-03'); - -> 2 - */ - class OOp_Month : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** DAYNAME(date) - Returns the name of the weekday for date: - - > SELECT DAYNAME('1998-02-05'); - -> 'Thursday' - - */ - class OOp_DayName : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** MONTHNAME(date) - Returns the name of the month for date: - - > SELECT MONTHNAME('1998-02-05'); - -> 'February' - - */ - class OOp_MonthName : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** QUARTER(date) - Returns the quarter of the year for date, in the range 1 to 4: - - > SELECT QUARTER('98-04-01'); - -> 2 - - */ - class OOp_Quarter : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** WEEK(date) - WEEK(date,first) - With a single argument, returns the week for date, in the range 0 to 53 (yes, there may be the beginnings of a week 53), for locations where Sunday is the first day of the week. The two-argument form of WEEK() allows you to specify whether the week starts on Sunday or Monday and whether the return value should be in the range 0-53 or 1-52. Here is a table for how the second argument works: - Value Meaning - 0 Week starts on Sunday and return value is in range 0-53 - 1 Week starts on Monday and return value is in range 0-53 - 2 Week starts on Sunday and return value is in range 1-53 - 3 Week starts on Monday and return value is in range 1-53 (ISO 8601) - - > SELECT WEEK('1998-02-20'); - -> 7 - > SELECT WEEK('1998-02-20',0); - -> 7 - > SELECT WEEK('1998-02-20',1); - -> 8 - > SELECT WEEK('1998-12-31',1); - -> 53 - - */ - class OOp_Week : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** YEAR(date) - Returns the year for date, in the range 1000 to 9999: - - > SELECT YEAR('98-02-03'); - -> 1998 - */ - class OOp_Year : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** HOUR(time) - Returns the hour for time, in the range 0 to 23: - - > SELECT HOUR('10:05:03'); - -> 10 - */ - class OOp_Hour : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** MINUTE(time) - Returns the minute for time, in the range 0 to 59: - - > SELECT MINUTE('98-02-03 10:05:03'); - -> 5 - - */ - class OOp_Minute : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** SECOND(time) - Returns the second for time, in the range 0 to 59: - - > SELECT SECOND('10:05:03'); - -> 3 - */ - class OOp_Second : public OUnaryOperator - { - protected: - virtual ORowSetValue operate(const ORowSetValue& lhs) const override; - }; - - /** CURDATE() - CURRENT_DATE - Returns today's date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context: - - > SELECT CURDATE(); - -> '1997-12-15' - */ - class OOp_CurDate : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** CURTIME() - CURRENT_TIME - Returns the current time as a value in 'HH:MM:SS' or HHMMSS format, depending on whether the function is used in a string or numeric context: - - > SELECT CURTIME(); - -> '23:50:26' - */ - class OOp_CurTime : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; - - /** NOW() - Returns the current date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context: - - > SELECT NOW(); - -> '1997-12-15 23:50:26' - */ - class OOp_Now : public ONthOperator - { - protected: - virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; - }; + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** DAYOFMONTH(date) + Returns the day of the month for date, in the range 1 to 31: + + > SELECT DAYOFMONTH('1998-02-03'); + -> 3 + */ + class OOp_DayOfMonth : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** DAYOFYEAR(date) + Returns the day of the year for date, in the range 1 to 366: + + > SELECT DAYOFYEAR('1998-02-03'); + -> 34 + + */ + class OOp_DayOfYear : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** MONTH(date) + Returns the month for date, in the range 1 to 12: + + > SELECT MONTH('1998-02-03'); + -> 2 + */ + class OOp_Month : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** DAYNAME(date) + Returns the name of the weekday for date: + + > SELECT DAYNAME('1998-02-05'); + -> 'Thursday' + + */ + class OOp_DayName : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** MONTHNAME(date) + Returns the name of the month for date: + + > SELECT MONTHNAME('1998-02-05'); + -> 'February' + + */ + class OOp_MonthName : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** QUARTER(date) + Returns the quarter of the year for date, in the range 1 to 4: + + > SELECT QUARTER('98-04-01'); + -> 2 + + */ + class OOp_Quarter : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** WEEK(date) + WEEK(date,first) + With a single argument, returns the week for date, in the range 0 to 53 (yes, there may be the beginnings of a week 53), for locations where Sunday is the first day of the week. The two-argument form of WEEK() allows you to specify whether the week starts on Sunday or Monday and whether the return value should be in the range 0-53 or 1-52. Here is a table for how the second argument works: + Value Meaning + 0 Week starts on Sunday and return value is in range 0-53 + 1 Week starts on Monday and return value is in range 0-53 + 2 Week starts on Sunday and return value is in range 1-53 + 3 Week starts on Monday and return value is in range 1-53 (ISO 8601) + + > SELECT WEEK('1998-02-20'); + -> 7 + > SELECT WEEK('1998-02-20',0); + -> 7 + > SELECT WEEK('1998-02-20',1); + -> 8 + > SELECT WEEK('1998-12-31',1); + -> 53 + + */ + class OOp_Week : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** YEAR(date) + Returns the year for date, in the range 1000 to 9999: + + > SELECT YEAR('98-02-03'); + -> 1998 + */ + class OOp_Year : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** HOUR(time) + Returns the hour for time, in the range 0 to 23: + + > SELECT HOUR('10:05:03'); + -> 10 + */ + class OOp_Hour : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** MINUTE(time) + Returns the minute for time, in the range 0 to 59: + + > SELECT MINUTE('98-02-03 10:05:03'); + -> 5 + + */ + class OOp_Minute : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** SECOND(time) + Returns the second for time, in the range 0 to 59: + + > SELECT SECOND('10:05:03'); + -> 3 + */ + class OOp_Second : public OUnaryOperator + { + protected: + virtual ORowSetValue operate(const ORowSetValue& lhs) const override; + }; + + /** CURDATE() + CURRENT_DATE + Returns today's date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context: + + > SELECT CURDATE(); + -> '1997-12-15' + */ + class OOp_CurDate : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** CURTIME() + CURRENT_TIME + Returns the current time as a value in 'HH:MM:SS' or HHMMSS format, depending on whether the function is used in a string or numeric context: + + > SELECT CURTIME(); + -> '23:50:26' + */ + class OOp_CurTime : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; + + /** NOW() + Returns the current date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context: + + > SELECT NOW(); + -> '1997-12-15 23:50:26' + */ + class OOp_Now : public ONthOperator + { + protected: + virtual ORowSetValue operate(const std::vector<ORowSetValue>& lhs) const override; + }; } |