Data Transformation Engine SQL/MP Adapter Reference Guide

Date and Time Formats Chapter 3 - Database Columns and Types
SQL/MP Adapter Reference Guide
11
NonStop SQL/MP DATETIME
Data Type
Results in an
mtsmaker-generated Type
Results in an
ODBC-generated Type
SECOND
DATETIME MONTH TO
FRACTION(d)
{MM-DD}:{HH24:MM[:SS
[.d-d]]}
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME DAY
{DD} {CCYY-MM-DD}
DATETIME DAY TO HOUR
{DD}:{HH24} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME DAY TO MINUTE
{DD}:{HH24:MM} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME DAY TO
SECOND
{DD}:{HH24:MM:SS} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME DAY TO
FRACTION(d)
{DD}:{HH24:MM[:SS[.d-d]]} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME HOUR
{HH24} {HH24:MM:SS}
DATETIME HOUR TO
MINUTE
{HH24:MM} {HH24:MM:SS}
DATETIME HOUR TO
SECOND
{HH24:MM:SS} {HH24:MM:SS}
DATETIME HOUR TO
FRACTION(d)
{HH24:MM[:SS[.d-d]]} {CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME MINUTE Presented as character
{HH24:MM:SS}
DATETIME MINUTE TO
SECOND
Presented as character
{HH24:MM:SS}
DATETIME MINUTE TO
FRACTION(d)
Presented as character
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME SECOND Presented as character
{HH24:MM:SS}
DATETIME SECOND TO
FRACTION(d)
Presented as character
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}
DATETIME FRACTION(d) Presented as character
{CCYY-MM-DD} {HH24:MM
[:SS[.6-6]]}