ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-8
Identifiers
SQL Server date functions contain arguments called dateparts. Table B-4 summarizes
the dateparts supported by the NonStop ODBC Server.
For detailed information on functions, see Functions on page 4-17.
Identifiers
The NonStop ODBC Server supports SQL Server identifiers for naming all objects
except databases and owners.
TEXTVALID – –
Type Conversion Function
CONVERT x The style parameter is ignored, and there are
restrictions when converting to or from a datetime
value.
Table B-4. NonStop ODBC Server Support of SQL Server Dateparts
Datepart Abbreviation NonStop ODBC Server Support
day dd x
dayofyear dy –
hour hh x
millisecond ms x
minute mi x
month mm x
quarter qq –
second ss x
week wk –
weekday wd –
year yy x
xIndicates a supported datepart
–Indicates an unsupported datepart
Table B-3. SQL Server Functions (page 4 of 4)
Function
NonStop ODBC
Server Support Comments
x Indicates a supported function
– Indicates an unsupported function