SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-8
D
Data types (continued)
REAL 6-37
character 6-22
comparable and compatible 6-17
datetime
DATE 6-26
TIME 6-26
TIMESTAMP 6-26
exact numeric
DECIMAL 6-36
descriptions of 6-35
INTEGER 6-35
LARGEINT 6-36
NUMERIC 6-35
PICTURE 6-36
SMALLINT 6-35
extended numeric precision 6-18
fixed length character
CHAR 6-23
NATIONAL CHAR 6-23
NCHAR 6-23
PIC 6-23
interval 6-31
Java 2-63
literals, examples of
character string literals 6-67
datetime literals 6-70
interval literals 6-75
numeric literals 6-76
varying-length character
CHAR VARYING 6-23
NATIONAL CHAR VARYING 6-23
NCHAR VARYING 6-23
VARCHAR 6-23
Database object names 6-13
Database object namespace 6-15
Database objects 6-12
Database sample tables D-1
DATASOURCES metadata table 10-92
DATA_FLOW_OPTIMIZATION
default 10-64
DATEFORMAT function
examples of 9-41
syntax diagram of 9-41
Datetime data types
DATE 6-26
description of 6-26
examples of literals 6-70
MP DATETIME data 6-29
TIME 6-26
TIMESTAMP 6-26
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-71
JULIANTIMESTAMP 9-73
MINUTE 9-91
MONTH 9-93
MONTHNAME 9-94
QUARTER 9-115
SECOND 9-149
WEEK 9-185
YEAR 9-186
Datetime literals
description of 6-68
inserting into SQL/MP columns 6-69
selecting from SQL/MP tables 6-28
Datetime value expression
examples of 6-44