/************************************************************************* * * $RCSfile: FDateFunctions.hxx,v $ * * $Revision: 1.2 $ * * last change: $Author: obo $ $Date: 2003-09-04 08:27:46 $ * * The Contents of this file are made available subject to the terms of * either of the following licenses * * - GNU Lesser General Public License Version 2.1 * - Sun Industry Standards Source License Version 1.1 * * Sun Microsystems Inc., October, 2000 * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2000 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * * * Sun Industry Standards Source License Version 1.1 * ================================================= * The contents of this file are subject to the Sun Industry Standards * Source License Version 1.1 (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.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. * * The Initial Developer of the Original Code is: Sun Microsystems, Inc. * * Copyright: 2000 by Sun Microsystems, Inc. * * All Rights Reserved. * * Contributor(s): _______________________________________ * * ************************************************************************/ #ifndef _CONNECTIVITY_FILE_FDATEFUNCTIONS_HXX_ #define _CONNECTIVITY_FILE_FDATEFUNCTIONS_HXX_ #include "file/fcode.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& 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& 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& 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& lhs) const; }; } } #endif // _CONNECTIVITY_FILE_FCODE_HXX_