Skip to main content

Abstract

Many database management systems and operating systems provide support for time values. This support is present at both the logical and physical levels. The logical level is the user ’s view of the time values and the query level operations permitted on those values, while the physical level concerns the bit layout of the time values and the bit level operations on those values. The physical level serves as a platform for the logical level but is inaccessible to the average user. This chapter presents aone design for the physical level of time values in TSQL2.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 259.00
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info
Hardcover Book
USD 329.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer Science+Business Media New York

About this chapter

Cite this chapter

Dyreson, C.E., Snodgrass, R.T. (1995). A Timestamp Representation. In: Snodgrass, R.T. (eds) The TSQL2 Temporal Query Language. The Springer International Series in Engineering and Computer Science, vol 330. Springer, Boston, MA. https://doi.org/10.1007/978-1-4615-2289-8_25

Download citation

  • DOI: https://doi.org/10.1007/978-1-4615-2289-8_25

  • Publisher Name: Springer, Boston, MA

  • Print ISBN: 978-1-4613-5966-1

  • Online ISBN: 978-1-4615-2289-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics