Neoview SQL Reference Manual (R2.2)

DECIMAL, 206
descriptions of, 205
INTEGER, 206
LARGEINT, 206
NUMERIC, 205
PICTURE, 206
SMALLINT, 206
fixed length character
CHAR, 200
NATIONAL CHAR, 201
NCHAR, 201
PIC, 201
interval, 204
literals, examples of
character string literals, 224
datetime literals, 225
interval literals, 228
numeric literals, 229
varying-length character
CHAR VARYING, 201
NATIONAL CHAR VARYING, 201
NCHAR VARYING, 201
VARCHAR, 201
Database object names, 196
Database object namespace, 196
Database objects, 195
DATE_ADD function
syntax diagram of, 318
DATE_PART (of a timestamp) function
syntax diagram of, 323
DATE_PART (of an interval) function
syntax diagram of, 322
DATE_SUB function
syntax diagram of, 319
DATE_TRUNC function
syntax diagram of, 324
DATEADD function
syntax diagram of, 319
DATEDIFF function
syntax diagram of, 321
DATEFORMAT function
examples of, 322
syntax diagram of, 322
Datetime data types
DATE, 202
description of, 202
examples of literals, 225
TIME, 202
TIMESTAMP, 202
Datetime functions
summary of, 281
ADD_MONTHS, 288
CONVERTTIMESTAMP, 307
CURRENT_DATE, 313
CURRENT_TIME, 315
CURRENT_TIMESTAMP, 316
DATE_TRUNC, 324
DATEFORMAT, 322
DAY, 325
DAYNAME, 326
DAYOFMONTH, 327
DAYOFWEEK, 328
DAYOFYEAR, 329
EXTRACT, 342
HOUR, 344
JULIANTIMESTAMP, 347
MINUTE, 363
MONTH, 365
MONTHNAME, 366
QUARTER, 385
SECOND, 403
WEEK, 432
YEAR, 433
Datetime literals
description of, 225
Datetime value expression
examples of, 211
syntax diagram of, 210
DAY function
examples of, 325
syntax diagram of, 325
DAYNAME function
examples of, 326
syntax diagram of, 326
DAYOFMONTH function
examples of, 327
syntax diagram of, 327
DAYOFWEEK function
examples of, 328
syntax diagram of, 328
DAYOFYEAR function
examples of, 329
syntax diagram of, 329
DDL statements (see Data Definition Language (DDL)
statements)
DECIMAL data type, 206
DECODE function
syntax diagram of, 330
DEFAULT clause
ALTER TABLE use of, 49
CREATE TABLE use of, 72, 258
examples of, 259
syntax diagram of, 258
DEFAULT value, using, 123, 170
DEGREES function
examples of, 333
syntax diagram of, 333
DELETE statement
access options, 91
SET ON ROLLBACK clause, 91
SET ROLLBACK clause, 91
SKIP CONFLICT access, 91
STREAM clause, 91, 170
syntax diagram of, 90
WHERE clause, 91
DELETE statement (embedded)
searched form, 90
Delimited identifiers, 220
452 Index