NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
T-5
TIMESTAMP Data Type
TIMESTAMP Data Type
Data of type TIMESTAMP represents a date according to the Gregorian calendar and a
time of day according to a 24-hour clock. Values of data type TIMESTAMP are
equivalent to values of data type DATETIME declared as:
DATETIME YEAR TO FRACTION(6)
See DATETIME Data Type on page D-14 if you need additional information.
Examples—TIMESTAMP Data Type
•
These are literals of data type TIMESTAMP in (respectively) default, USA, and
European format:
TIMESTAMP "1990-01-22:13:40:05.55"
TIMESTAMP "01/22/1990 01:40:05.55 PM"
TIMESTAMP "22.01.1990 01.13.05.55 PM"
See DATE-TIME Literals on page D-9 if you need additional information.
TMF Transactions
The Transaction Management Facility (TMF) subsystem simplifies the task of
maintaining data consistency for a distributed database being updated by concurrent
transactions.
A TMF transaction (a set of database changes that must be completed as a group) is the
basic recoverable unit if a failure or transaction interruption occurs. TMF transactions
can be defined during an SQLCI session or in a host program. The typical order of
events is:
1. Transaction is started.
2. Database changes are made.
3. Transaction is committed.
If, however, the changes cannot be made or the user does not want to complete the
transaction, the transaction can be aborted so the database is rolled back to its original
state.