ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-14
Data Types
The date can be any of the following:
The time can be any of the following:
The mixed datetime can be any of the following:
Table 4-5 lists the datetime fields.
monthn { . } day { . } year
{ - } { - }
{ / } { / }
year4
YYYYMMDD
YYMMDD
day { . } day { . } year
{ - } { - }
{ / } { / }
month [ , ] day [ , ] year
day [ , ] month [ , ] year
day [ , ] year month
year month
year4 month [ , ] day
month [ , ] year4
hour { AM }
{ PM }
hour:minute [ AM ]
[ PM ]
hour:minute:second [ AM ]
[ PM ]
hour:minute:second:millisecond [ AM ]
[ PM ]
hour:minute:second:millisecond [ AM ]
[ PM ]
month [ , ] day [ , ] time year
day [ , ] month [ , ] time year