Neoview SQL Reference Manual (R2.3)

DELETE statement, 91
INSERT statement, 124
SELECT statement, 145
UPDATE statement, 179
Data type conversion, CAST expression, 309
Data types
approximate numeric
descriptions of, 215
DOUBLE PRECISION, 216
FLOAT, 216
REAL, 216
character, 210
comparable and compatible, 209
datetime
DATE, 212
TIME, 212
TIMESTAMP, 212
exact numeric
DECIMAL, 216
descriptions of, 215
INTEGER, 216
LARGEINT, 216
NUMERIC, 215
PICTURE, 216
SMALLINT, 216
fixed length character
CHAR, 210
NATIONAL CHAR, 211
NCHAR, 211
PIC, 211
interval, 214
literals, examples of
character string literals, 234
datetime literals, 235
interval literals, 238
numeric literals, 239
varying-length character
CHAR VARYING, 211
NATIONAL CHAR VARYING, 211
NCHAR VARYING, 211
VARCHAR, 211
Database object names, 206
Database object namespace, 206
Database objects, 205
DATE_ADD function
syntax diagram of, 329
DATE_PART (of a timestamp) function
syntax diagram of, 334
DATE_PART (of an interval) function
syntax diagram of, 333
DATE_SUB function
syntax diagram of, 330
DATE_TRUNC function
syntax diagram of, 335
DATEADD function
syntax diagram of, 330
DATEDIFF function
syntax diagram of, 332
DATEFORMAT function
examples of, 333
syntax diagram of, 333
Datetime data types
DATE, 212
description of, 212
examples of literals, 235
TIME, 212
TIMESTAMP, 212
Datetime functions
summary of, 291
ADD_MONTHS, 298
CONVERTTIMESTAMP, 318
CURRENT_DATE, 324
CURRENT_TIME, 326
CURRENT_TIMESTAMP, 327
DATE_TRUNC, 335
DATEFORMAT, 333
DAY, 336
DAYNAME, 337
DAYOFMONTH, 338
DAYOFWEEK, 339
DAYOFYEAR, 340
EXTRACT, 353
HOUR, 355
JULIANTIMESTAMP, 358
MINUTE, 374
MONTH, 376
MONTHNAME, 377
QUARTER, 396
SECOND, 414
WEEK, 443
YEAR, 444
Datetime literals
description of, 235
Datetime value expression
examples of, 221
syntax diagram of, 220
DAY function
examples of, 336
syntax diagram of, 336
DAYNAME function
examples of, 337
syntax diagram of, 337
DAYOFMONTH function
examples of, 338
syntax diagram of, 338
DAYOFWEEK function
examples of, 339
syntax diagram of, 339
DAYOFYEAR function
examples of, 340
syntax diagram of, 340
DDL statements (see Data Definition Language (DDL)
statements)
DECIMAL data type, 216
DECODE function
syntax diagram of, 341
DEFAULT clause
ALTER TABLE use of, 49
474 Index