| /************************************************************** |
| * |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| #ifndef _CONNECTIVITY_FILE_FDATEFUNCTIONS_HXX_ |
| #define _CONNECTIVITY_FILE_FDATEFUNCTIONS_HXX_ |
| |
| #include "file/fcode.hxx" |
| #include "file/filedllapi.hxx" |
| |
| namespace connectivity |
| { |
| class OSQLParseNode; |
| namespace 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 |
| { |
| protected: |
| virtual ORowSetValue operate(const ORowSetValue& lhs) const; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| |
| /** 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; |
| }; |
| } |
| } |
| |
| #endif // _CONNECTIVITY_FILE_FCODE_HXX_ |
| |