1.1.1

DbDataReader.GetInt16ADO.NET getter
TIME
Provides for storage of time of day as hour-minutes-seconds. Supported formats are:
hh:mm[:ss]
hh.mm[.ss]
hh[:mm] {AM | PM}
Hours (hh) may have one or two digits, while minutes (mm) and seconds (ss), if present, must have two digits.
DATEs, TIMEs, and TIMESTAMPs must not be mixed with one another in expressions except with an explicit
CAST.
java.sql.TimeEquivalent Java type
java.sql.Types.TIMEJDBC metadata type
ResultSet.getTime, PreparedStatement.setTimeJDBC methods
System.DateTimeEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.TimeADO.NET metadata type
TimeADO.NET mapped System.Data.Dbtype
DbDataReader.GetDateTimeADO.NET getter
Example
VALUES '13:23:12'
VALUES TIME('13:23:12')
The latter example uses the TIME() function described in the section Built-in functions and procedures.
TIMESTAMP
Provides for storage of both DATE and TIME as a combined value. In addition it allows for fractional seconds
having up to six digits. Supported formats are:
yyyy-MM-dd hh:mm:ss[.nnnnnn]
yyyy-MM-dd-hh.mm.ss[.nnnnnn]
The year (yyyy) must always be expressed with four digits. Months (MM), days (dd), and hours (hh) may have
one or two digits while minutes (mm) and seconds (ss) must have two digits. Microseconds, if present, may have
between one and six digits. DATEs, TIMEs, and TIMESTAMPs must not be mixed with one another in expressions
except with an explicit CAST.
java.sql.TimestampEquivalent Java type
java.sql.Types.TIMESTAMPJDBC metadata type
ResultSet.getTimestamp, PreparedStatement.setTimestampJDBC methods
System.DateTimeEquivalent .NET type
Vmware.Data.SQLFire.SQLFType.TimeStampADO.NET metadata type
vFabric SQLFire User's Guide632
vFabric SQLFire Reference