ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-15
Data Types
For more information, see the following documents:
Retrieving and Manipulating NonStop SQL/MP Data and
Objects
If you use the NonStop ODBC Server to access data and objects that were created
with NonStop SQL/MP, the NonStop ODBC Server converts the NonStop SQL/MP data
types and values to Transact-SQL data types and values.
Table 4-6 summarizes the NonStop SQL/MP data types, corresponding Transact-SQL
data types, and conversion information.
Table 4-5. Datetime Fields
Field Meaning Comments and Valid Values
day Day within a month 1 or 01 to 31
month Month within a year
(in alphabetic format)
January to December
monthn Month in numeric format 1 or 01 to 12
year Year 1 to 4 digits
year4 4-digit year Must be 4 digits
hour Hour within a day 0 or 00 to 23
minute Minute within an hour 0 or 00 to 59
second Second within a minute 0 or 00 to 59
millisecond Millisecond within a second 0 or 00 to 999
For Information On See
Transact-SQL data types Microsoft SQL Server Transact-SQL Reference
NonStop SQL/MP data types NonStop SQL/MP Reference Manual
Transact-SQL dateparts Date Functions
on page 4-19
Microsoft SQL Server Transact-SQL Reference
Table 4-6. Converting NonStop SQL/MP Data Types to Transact-SQL Data
Types (page 1 of 3)
NonStop SQL/MP
Data Type
Does the Object
Accept Null Values?
Corresponding Transact-SQL Data
Type
CHARACTER – CHAR if value is 0–255
VARCHAR if value is 256–4050
x VARCHAR
DATE – DATETIME
x Indicates the column accepts null values
– Indicates the column does not accept null values