символьных типов ............................................................................. 40 CHAR ................................................................................................. строками .............................................................................. 424 ASCII_CHAR ................................................................................................. ............................................ 425 Руководство по языку SQL СУБД Firebird 3.0 15 CHAR_LENGTH, CHARACTER_LENGTH ............................................................ 426 HASH ..

ACOS() ASCII_CHAR() 7 Руководство по языку SQL ASCII_VAL() ASIN() ATAN() ATAN2() BIN_AND() BIN_OR() BIN_SHL() BIN_SHR() BIN_XOR() BIT_LENGTH() CAST() CEIL(), CEILING() CHAR_LENGTH(), CHARACTER_LENGTH() CHARACTER_LENGTH() CHAR_TO_UUID() COALESCE() COS() COSH() COT() DATEADD() DATEDIFF() DECODE() EXP() EXTRACT() MILLISECOND WEEK FLOOR() GEN_ID() GEN_UUID() HASH() IIF() LEFT() LN() LOG() LOG10() TANH() TRIM() TRUNC() UPPER() UUID_TO_CHAR() 15.Внешние функции (UDF) abs acos addDay addHour addMilliSecond addMinute addMonth addSecond addWeek addYear ascii_char ascii_val asin atan atan2 bin_and bin_or

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 432 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 436 8.3.7. CHAR_LENGTH(), CHARACTER_LENGTH() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 470 8.7.1. CHAR_TO_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 327 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 329 8.3.4. CHAR_LENGTH(), CHARACTER_LENGTH() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 357 8.7.1. CHAR_TO_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 419 8.3.1. ASCII_CHAR() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 420 8.3.4. CHAR_LENGTH(), CHARACTER_LENGTH() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 450 8.7.1. CHAR_TO_UUID() . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Formatting....................................................................................166 9-24. to_char Examples......................................................................................... — you choose.) PostgreSQL supports the standard SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and scheme like this: CREATE TABLE capitals ( name text, population real, altitude int, -- (in ft) state char(2) ); CREATE TABLE non_capitals ( name text, population real, altitude int -- (in ft) 19 Chapter

Formatting....................................................................................166 9-24. to_char Examples......................................................................................... — you choose.) PostgreSQL supports the standard SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and scheme like this: CREATE TABLE capitals ( name text, population real, altitude int, -- (in ft) state char(2) ); CREATE TABLE non_capitals ( name text, population real, altitude int -- (in ft) 19 Chapter

Formatting.............................................................................143 9-24. to_char Examples......................................................................................... — you choose.) PostgreSQL supports the standard SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and scheme like this: CREATE TABLE capitals ( name text, population real, altitude int, -- (in ft) state char(2) ); CREATE TABLE non_capitals ( name text, population real, altitude int -- (in ft) ); CREATE

NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL ); Let us create one more table, which we will use in our exercises chapters: sqlite> CREATE TABLE DEPARTMENT( ID INT PRIMARY KEY NOT NULL, DEPT CHAR(50) NOT NULL, EMP_ID INT NOT NULL ); CHAPTER 9 TUTORIALS POINT Simply Easy NULL, NAME TEXT NOT NULL, AGE INT NOT NULL, ADDRESS CHAR(50), SALARY REAL ); TUTORIALS POINT Simply Easy Learning

Formatting....................................................................................151 9-24. to_char Examples......................................................................................... — you choose.) PostgreSQL supports the standard SQL types int, smallint, real, double precision, char(N), varchar(N), date, time, timestamp, and interval, as well as other types of general utility and scheme like this: CREATE TABLE capitals ( name text, population real, altitude int, -- (in ft) state char(2) ); CREATE TABLE non_capitals ( name text, population real, altitude int -- (in ft) 19 Chapter