SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-8
D
Data types (continued)
comparable and compatible 6-17
datetime
DATE 6-24
TIME 6-24
TIMESTAMP 6-24
exact numeric
DECIMAL 6-33
descriptions of 6-32
INTEGER 6-33
LARGEINT 6-33
NUMERIC 6-33
PICTURE 6-34
SMALLINT 6-33
fixed length character
CHAR 6-21
NATIONAL CHAR 6-21
NCHAR 6-21
PIC 6-21
interval 6-29
Java 2-65
literals, examples of
character string literals 6-64
datetime literals 6-67
interval literals 6-72
numeric literals 6-73
varying-length character
CHAR VARYING 6-21
NATIONAL CHAR VARYING 6-21
NCHAR VARYING 6-21
VARCHAR 6-21
Database object names 6-13
Database object namespace 6-15
Database objects 6-12
Database sample tables D-1
DATASOURCES metadata table 10-85
DATA_FLOW_OPTIMIZATION
default 10-58
DATEFORMAT function
examples of 9-41
DATEFORMAT function (continued)
syntax diagram of 9-41
Datetime data types
DATE 6-24
description of 6-24
examples of literals 6-67
MP DATETIME data 6-27
TIME 6-24
TIMESTAMP 6-24
Datetime functions
summary of 9-4
CONVERTTIMESTAMP 9-33
CURRENT_DATE 9-38
CURRENT_TIME 9-39
CURRENT_TIMESTAMP 9-40
DATEFORMAT 9-41
DAY 9-42
DAYNAME 9-43
DAYOFMONTH 9-44
DAYOFWEEK 9-45
DAYOFYEAR 9-46
EXTRACT 9-63
HOUR 9-69
JULIANTIMESTAMP 9-71
MINUTE 9-87
MONTH 9-89
MONTHNAME 9-90
QUARTER 9-111
SECOND 9-142
WEEK 9-175
YEAR 9-176
Datetime literals
description of 6-65
inserting into SQL/MP columns 6-66
selecting from SQL/MP tables 6-26
Datetime value expression
examples of 6-41
syntax diagram of 6-40