Data Transformation Engine SQL/MP Adapter Reference Guide

Date and Time Formats Chapter 3 - Database Columns and Types
SQL/MP Adapter Reference Guide
10
Available NonStop SQL/MP Formats
The NonStop SQL/MP database environment provides many more data types for
DATETIME than ODBC provides (as indicated in the following table). To take
advantage of this functionality, you may need to either use mtsmaker to
generate your type trees (instead of the Database Interface Designer) or you can
manually edit these values in the Type Designer. For more information about
generating type trees using mtsmaker, refer to the Resource Adapters Reference
Guide.
NonStop SQL/MP DATETIME
Data Type
Results in an
mtsmaker-generated Type
Results in an
ODBC-generated Type
DATE
{CCYY-MM-DD} {CCYY-MM-DD}
TIME
{HH24:MM:SS} {HH24:MM:SS}
TIMESTAMP
{CCYY-MM-DD}:{HH24:MM
[:SS[.6-6]]}
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME YEAR
{CCYY} {CCYY-MM-DD}
DATETIME YEAR TO
MONTH
{CCYY-MM} {CCYY-MM-DD}
DATETIME YEAR TO DAY
{CCYY-MM-DD} {CCYY-MM-DD}
DATETIME YEAR TO HOUR
{CCYY-MM-DD}:{HH24} {CCYY-MM-DD}
{HH24:MM[:SS[.6-6]]}
DATETIME YEAR TO
MINUTE
{CCYY-MM-DD}:{HH24:MM} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME YEAR TO
SECOND
{CCYY-MM-DD}:{HH24:MM
[:SS]}
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME YEAR TO
FRACTION(d)
{CCYY-MM-DD}:{HH24:MM[:SS
[.d-d]]}
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME MONTH
{MM} {CCYY-MM-DD}
DATETIME MONTH TO DAY
{MM-DD} {CCYY-MM-DD}
DATETIME MONTH TO
HOUR
{MM-DD}:{HH24} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME MONTH TO
MINUTE
{MM-DD}:{HH24:MM} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME MONTH TO
{MM-DD}:{HH24:MM:SS} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}