Institute of Mathematics and Informatics Bulgarian Academy of Sciences
Serdica Journal of Computing, Vol. 12, No 4, (2018), 247p-264p
Date and time data types are very important for the
business. From the relational model data point of view, these data
types are simply atomic domains - their structure and operations are
unimportant. After the initial introduction of the relational model of
data and the next following implementations based on that model, Codd,
in the Version 2 of relational model of data, corrected his point of
view introducing 14 recommendations about date and time data types.
This paper investigate date and time data types implementations in ISO
SQL, DB2, Oracle and Transact-SQL.