Codd’s Recommendations for Date Time Data Types and its implementations in ISO SQL, DB2, Oracle, and Transact-SQL
Serdica Journal of Computing, Tome 12 (2018) no. 4, pp. 247-264
Cet article a éte moissonné depuis la source Bulgarian Digital Mathematics Library
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.
Keywords:
Codd, SQL, Database
@article{SJC_2018_12_4_a2,
author = {Dimitrov, Vladimir},
title = {Codd{\textquoteright}s {Recommendations} for {Date} & {Time} {Data} {Types} and its implementations in {ISO} {SQL,} {DB2,} {Oracle,} and {Transact-SQL}},
journal = {Serdica Journal of Computing},
pages = {247--264},
year = {2018},
volume = {12},
number = {4},
language = {en},
url = {http://geodesic.mathdoc.fr/item/SJC_2018_12_4_a2/}
}
TY - JOUR AU - Dimitrov, Vladimir TI - Codd’s Recommendations for Date & Time Data Types and its implementations in ISO SQL, DB2, Oracle, and Transact-SQL JO - Serdica Journal of Computing PY - 2018 SP - 247 EP - 264 VL - 12 IS - 4 UR - http://geodesic.mathdoc.fr/item/SJC_2018_12_4_a2/ LA - en ID - SJC_2018_12_4_a2 ER -
%0 Journal Article %A Dimitrov, Vladimir %T Codd’s Recommendations for Date & Time Data Types and its implementations in ISO SQL, DB2, Oracle, and Transact-SQL %J Serdica Journal of Computing %D 2018 %P 247-264 %V 12 %N 4 %U http://geodesic.mathdoc.fr/item/SJC_2018_12_4_a2/ %G en %F SJC_2018_12_4_a2
Dimitrov, Vladimir. Codd’s Recommendations for Date & Time Data Types and its implementations in ISO SQL, DB2, Oracle, and Transact-SQL. Serdica Journal of Computing, Tome 12 (2018) no. 4, pp. 247-264. http://geodesic.mathdoc.fr/item/SJC_2018_12_4_a2/