SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-8
D
Data types (continued)
comparable and compatible 6-16
datetime
DATE 6-23
TIME 6-23
TIMESTAMP 6-23
exact numeric
DECIMAL 6-32
descriptions of 6-31
INTEGER 6-32
LARGEINT 6-32
NUMERIC 6-32
PICTURE 6-33
SMALLINT 6-32
fixed length character
CHAR 6-20
NATIONAL CHAR 6-20
NCHAR 6-20
PIC 6-20
interval 6-28
Java 2-61
literals, examples of
character string literals 6-63
datetime literals 6-66
interval literals 6-71
numeric literals 6-72
varying-length character
CHAR VARYING 6-20
NATIONAL CHAR VARYING 6-20
NCHAR VARYING 6-20
VARCHAR 6-20
Database object names 6-12
Database object namespace 6-14
Database objects 6-11
Database sample tables D-1
DATASOURCES metadata table 10-80
DATA_FLOW_OPTIMIZATION
default 10-54
DATEFORMAT function
examples of 9-38
syntax diagram of 9-38
Datetime data types
DATE 6-23
description of 6-23
examples of literals 6-66
MP DATETIME data 6-26
TIME 6-23
TIMESTAMP 6-23
Datetime functions
summary of 9-4
CONVERTTIMESTAMP 9-30
CURRENT_DATE 9-35
CURRENT_TIME 9-36
CURRENT_TIMESTAMP 9-37
DATEFORMAT 9-38
DAY 9-39
DAYNAME 9-40
DAYOFMONTH 9-41
DAYOFWEEK 9-42
DAYOFYEAR 9-43
EXTRACT 9-59
HOUR 9-65
JULIANTIMESTAMP 9-67
MINUTE 9-83
MONTH 9-85
MONTHNAME 9-86
QUARTER 9-107
SECOND 9-138
WEEK 9-171
YEAR 9-172
Datetime literals
description of 6-64
inserting into SQL/MP columns 6-65
selecting from SQL/MP tables 6-25
Datetime value expression
examples of 6-40
syntax diagram of 6-39