Data Definition Language (DDL) Reference Manual

Dictionary Database Structure
Data Definition Language (DDL) Reference Manual—529431-004
D-36
DICTOBL (Object Build List)
39 SQL DATETIME DAY TO HOUR 5
40 SQL DATETIME MONTH TO HOUR 8
41 SQL DATETIME YEAR TO HOUR 13
42 SQL DATETIME MINUTE 2
43 SQL DATETIME HOUR TO MINUTE 5
44 SQL DATETIME DAY TO MINUTE 8
45 SQL DATETIME MONTH TO MINUTE 11
46 SQL DATETIME YEAR TO MINUTE 16
47 SQL DATETIME SECOND 2
48 SQL DATETIME MINUTE TO SECOND 5
49 SQL DATETIME HOUR TO SECOND 8
50 SQL DATETIME DAY TO SECOND 11
51 SQL DATETIME MONTH TO SECOND 14
52 SQL DATETIME YEAR TO SECOND 19
53 SQL DATETIME FRACTION 6
54 SQL DATETIME SECOND TO FRACTION 9
55 SQL DATETIME MINUTE TO FRACTION 12
56 SQL DATETIME HOUR TO FRACTION 15
57 SQL DATETIME DAY TO FRACTION 18
58 SQL DATETIME MONTH TO FRACTION 21
59 SQL DATETIME YEAR TO FRACTION 26
Table D-13. SQL INTERVAL Element Sizes (page1of2)
Code Meaning Element
60 SQL INTERVAL YEAR 3
61 SQL INTERVAL MONTH 3
62 SQL INTERVAL YEAR TO MONTH 6
63 SQL INTERVAL DAY 3
64 SQL INTERVAL HOUR 3
65 SQL INTERVAL DAY TO HOUR 6
66 SQL INTERVAL MINUTE 3
67 SQL INTERVAL HOUR TO MINUTE 6
68 SQL INTERVAL DAY TO MINUTE 9
69 SQL INTERVAL SECOND 3
Table D-12. SQL DATETIME Element Sizes (page 2 of 2)
Code Meaning Element Size