Neoview SQL Reference Manual (R2.4 SP2)

DATEFORMAT function
examples of, 371
syntax diagram of, 371
Datetime data types
DATE, 237
description of, 237
examples of literals, 263
TIME, 237
TIMESTAMP, 237
Datetime functions
summary of, 327
ADD_MONTHS, 334
CONVERTTIMESTAMP, 356
CURRENT, 361
CURRENT_DATE, 362
CURRENT_TIME, 364
CURRENT_TIMESTAMP, 365
DATE_ADD, 367
DATE_PART (interval), 372
DATE_PART (timestamp), 373
DATE_SUB, 368
DATE_TRUNC, 374
DATEADD, 369
DATEDIFF, 370
DATEFORMAT, 371
DAY, 375
DAYNAME, 376
DAYOFMONTH, 377
DAYOFWEEK, 378
DAYOFYEAR, 379
EXTRACT, 392
HOUR, 394
JULIANTIMESTAMP, 397
MINUTE, 409
MONTH, 411
MONTHNAME, 412
QUARTER, 430
SECOND, 451
TIMESTAMPADD, 465
TIMESTAMPDIFF, 466
WEEK, 475
YEAR, 476
Datetime literals
description of, 263
Datetime value expression
examples of, 246
syntax diagram of, 245
DAY function
examples of, 375
syntax diagram of, 375
DAYNAME function
examples of, 376
syntax diagram of, 376
DAYOFMONTH function
examples of, 377
syntax diagram of, 377
DAYOFWEEK function
examples of, 378
syntax diagram of, 378
DAYOFYEAR function
examples of, 379
syntax diagram of, 379
DDL statements (see Data Definition Language (DDL)
statements)
DECIMAL data type, 241
DECODE function
examples of, 381
syntax diagram of, 380
DEFAULT clause
ALTER TABLE use of, 45
CREATE TABLE use of, 75, 302
examples of, 303
syntax diagram of, 302
DEFAULT value, using, 198
DEGREES function
examples of, 383
syntax diagram of, 383
DELETE statement
access options, 107
authorization requirements, 108
considerations for, 108
examples of, 109
isolation levels, 108
long running delete, 108
SET ON ROLLBACK clause, 107
SKIP CONFLICT access, 108
STREAM clause, 107, 198
syntax diagram of, 106
WHERE clause, 107
Delimited identifiers, 257
DENSE_RANK window function
examples of, 485
syntax diagram of, 485
Derived column names
examples of, 226
syntax of, 225
DETAIL_COST in EXPLAIN output
CPU_TIME, 129, 390
IDLETIME, 129, 391
IO_TIME, 129, 390
MSG_TIME, 129, 390
PROBES, 129, 391
DIFF1 function
equivalent definitions, 384
examples of, 384
syntax diagram of, 384
DIFF2 function
equivalent definitions, 386
examples of, 386
syntax diagram of, 386
DISK POOL
considerations for, 91
description for, 75
examples of, 92
restrictions for, 91
DISTINCT clause
aggregate functions, 174, 325
AVG function use of, 339
527