Neoview SQL Reference Manual (R2.4)

syntax diagram of, 362
Datetime data types
DATE, 235
description of, 235
examples of literals, 258
TIME, 235
TIMESTAMP, 235
Datetime functions
summary of, 319
ADD_MONTHS, 326
CONVERTTIMESTAMP, 347
CURRENT, 352
CURRENT_DATE, 353
CURRENT_TIME, 355
CURRENT_TIMESTAMP, 356
DATE_ADD, 358
DATE_PART (interval), 363
DATE_PART (timestamp), 364
DATE_SUB, 359
DATE_TRUNC, 365
DATEADD, 360
DATEDIFF, 361
DATEFORMAT, 362
DAY, 366
DAYNAME, 367
DAYOFMONTH, 368
DAYOFWEEK, 369
DAYOFYEAR, 370
EXTRACT, 383
HOUR, 385
JULIANTIMESTAMP, 388
MINUTE, 404
MONTH, 406
MONTHNAME, 407
QUARTER, 425
SECOND, 446
TIMESTAMPADD, 460
TIMESTAMPDIFF, 461
WEEK, 477
YEAR, 478
Datetime literals
description of, 258
Datetime value expression
examples of, 243
syntax diagram of, 242
DAY function
examples of, 366
syntax diagram of, 366
DAYNAME function
examples of, 367
syntax diagram of, 367
DAYOFMONTH function
examples of, 368
syntax diagram of, 368
DAYOFWEEK function
examples of, 369
syntax diagram of, 369
DAYOFYEAR function
examples of, 370
syntax diagram of, 370
DDL statements (see Data Definition Language (DDL)
statements)
DECIMAL data type, 239
DECODE function
examples of, 372
syntax diagram of, 371
DEFAULT clause
ALTER TABLE use of, 47
CREATE TABLE use of, 74, 294
examples of, 295
syntax diagram of, 294
DEFAULT value, using, 143, 197
DEGREES function
examples of, 374
syntax diagram of, 374
DELETE statement
access options, 106
SET ON ROLLBACK clause, 106
SKIP CONFLICT access, 107
STREAM clause, 106, 197
syntax diagram of, 105
WHERE clause, 106
DELETE statement (embedded)
searched form, 105
Delimited identifiers, 252
DENSE_RANK window function
examples of, 487
syntax diagram of, 487
Derived column names
examples of, 224
syntax of, 223
DETAIL_COST in EXPLAIN output
CPU_TIME, 127, 381
IDLETIME, 127, 382
IO_TIME, 127, 381
MSG_TIME, 127, 381
PROBES, 127, 382
DIFF1 function
equivalent definitions, 375
examples of, 375
syntax diagram of, 375
DIFF2 function
equivalent definitions, 377
examples of, 377
syntax diagram of, 377
DISK POOL, 89
considerations for, 89
description for, 73
examples of, 90
restrictions for, 89
DISTINCT clause
aggregate functions, 174, 317
AVG function use of, 331
COUNT function use of, 350
MAX function use of, 402
MAXIMUM function use of, 402
MIN function use of, 403
STDDEV function use of, 452
519