SQL 機能（する）／行事s for とじ込み／提出する based database drivers

Feature Specification

Content

Abstract

The 現在のとじ込み／提出する based database drivers in OOo 1.0-1.1 (dBase, flat とじ込み／提出する, and spreadsheet) dosn't support any SQL 機能（する）／行事s. Neither string, date nor numeric 機能（する）／行事s. In the new 見解／翻訳／版 OOo 2.0 these drivers will support the に引き続いて機能（する）／行事s.

機能の description

String 機能（する）／行事s

UCASE(str)
UPPER(str)
Returns the string str with all characters changed to uppercase によれば the ascii character 始める，決める mapping.
LCASE(str)
LOWER(str)
Returns the string str with all characters changed to lowercase によれば the ascii character 始める，決める mapping.
ASCII(str)
Returns the ASCII code value of the leftmost character of the string str. Returns 0 if str is the empty string. Returns NULL if str is NULL:
LENGTH(str)
OCTET_LENGTH(str)
CHAR_LENGTH(str)
CHARACTER_LENGTH(str)
Returns the length of the string str:
CHAR(N,...)
CHAR() 解釈する／通訳するs the arguments as integers and returns a string consisting of the characters given by the ASCII code values of those integers. NULL values are skipped:
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments. Returns NULL if any argument is NULL. May have more than 2 arguments. A numeric argument is 変えるd to the 同等（の） string form.
LOCATE(substr,str)
Returns the position of the first occurrence of substring substr in string str. Returns 0 if substr is not in str.
SUBSTRING(str,pos)
Returns a substring from string str starting at position pos.
SUBSTRING(str,pos,len)
SUBSTRING(str FROM pos FOR len)
Returns a substring len characters long from string str, starting at position pos. The variant form that uses FROM is SQL-92 syntax.
LTRIM(str)
Returns the string str with 主要な space characters 除去するd.
RTRIM(str)
Returns the string str with 追跡するing space characters 除去するd.
SPACE(N)
Returns a string consisting of N space characters.
REPLACE(str,from_str,to_str)
Returns the string str with all occurrences of the string from_str 取って代わるd by the string to_str.
REPEAT(str,count)
Returns a string consisting of the string str repeated count times. If count <= 0, returns an empty string. Returns NULL if str or count are NULL.
INSERT(str,pos,len,newstr)
Returns the string str, with the substring beginning at position pos and len characters long 取って代わるd by the string newstr.
LEFT(str,len)
Returns the leftmost len characters from the string str.
RIGHT(str,len)
Returns the rightmost len characters from the string str.

Numeric fucntions

ABS(X)
Returns the 絶対の value of X.
SIGN(X)
Returns the 調印する of the argument as -1, 0, or 1, depending on whether X is 消極的な, 無, or 肯定的な.
MOD(N,M)
Modulo (like the % 操作者 in C). Returns the 残りの人，物 of N divided by M.
FLOOR(X)
Returns the largest integer value not greater than X.
CEILING(X)
Returns the smallest integer value not いっそう少なく than X.
ROUND(X)
ROUND(X,D)
Returns the argument X, 一連の会議、交渉／完成するd to the nearest integer. With two arguments 一連の会議、交渉／完成するd to a number to D decimals.
EXP(X)
Returns the value of e (the base of natural logarithms) raised to the 力／強力にする of X.
LN(X)
Returns the natural logarithm of X.
LOG(X)
LOG(B,X)
If called with one parameter, this 機能（する）／行事 returns the natural logarithm of X. If called with two parameters, this 機能（する）／行事 returns the logarithm of X for an arbitary base B.
LOG10(X)
Returns the base-10 logarithm of X.
POWER(X,Y)
Returns the value of X raised to the 力／強力にする of Y.
SQRT(X)
Returns the 非，不，無-消極的な square root of X.
PI()
Returns the value of PI.
COS(X)
Returns the cosine of X, where X is given in radians.
SIN(X)
Returns the sine of X, where X is given in radians.
TAN(X)
Returns the tangent of X, where X is given in radians.
ACOS(X)
Returns the arc cosine of X, that is, the value whose cosine is X. Returns NULL if X is not in the 範囲 -1 to 1.
ASIN(X)
Returns the arc sine of X, that is, the value whose sine is X. Returns NULL if X is not in the 範囲 -1 to 1.
ATAN(X)
Returns the arc tangent of X, that is, the value whose tangent is X.
ATAN2(Y,X)
Returns the arc tangent of the two variables X and Y. It is 類似の to calculating the arc tangent of Y / X, except that the 調印するs of both arguments are used to 決定する the quadrant of the result.
DEGREES(X)
Returns the argument X, 変えるd from radians to degrees.
RADIANS(X)
Returns the argument X, 変えるd from degrees to radians.

DateTime 機能（する）／行事s

DAYOFWEEK(date)
Returns the weekday 索引 for date (1 = Sunday, 2 = Monday, ... 7 = Saturday). These 索引 values correspond to the ODBC 基準.
DAYOFMONTH(date)
Returns the day of the month for date, in the 範囲 1 to 31.
DAYOFYEAR(date)
Returns the day of the year for date, in the 範囲 1 to 366.
MONTH(date)
Returns the month for date, in the 範囲 1 to 12.
DAYNAME(date)
Returns the 指名する of the weekday for date.
MONTHNAME(date)
Returns the 指名する of the month for date.
QUARTER(date)
Returns the ４半期/4分の1 of the year for date, in the 範囲 1 to 4.
WEEK(date)
WEEK(date,first)
With a 選び出す／独身 argument, returns the week for date, in the 範囲 0 to 53 (yes, there may be the beginnings of a week 53), for 場所s where Sunday is the first day of the week. The two-argument form of WEEK() 許すs you to 明示する whether the week starts on Sunday or Monday and whether the return value should be in the 範囲 0-53 or 1-52. Here is a （米）棚上げする／（英）提議する for how the second argument 作品:
                Value     Meaning
                0     Week starts on Sunday and return value is in 範囲 0-53
                1     Week starts on Monday and return value is in 範囲 0-53
YEAR(date)
Returns the year for date.
HOUR(time)
Returns the hour for time, in the 範囲 0 to 23.
MINUTE(time)
Returns the minute for time, in the 範囲 0 to 59.
SECOND(time)
Returns the second for time, in the 範囲 0 to 59.
CURDATE()
Returns today's date as a value in 'YYYY-MM-DD' or YYYYMMDD 判型, depending on whether the 機能（する）／行事 is used in a string or numeric 状況.
CURTIME()
Returns the 現在の time as a value in 'HH:MM:SS' or HHMMSS 判型, depending on whether the 機能（する）／行事 is used in a string or numeric 状況.
NOW()
Returns the 現在の date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS 判型, depending on whether the 機能（する）／行事 is used in a string or numeric 状況.