• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Complex Attributes > Date and Time Values

Date and Time Values

Like logical values, date and time values aren't nearly as simple as they might first appear. First, there is the issue of how the values are stored. (See the Sidebar, “Counting Time,” for a description of DateTime data types.) It isn't often an issue, but you do need to be aware of the differences in storage formats if you're dealing with historical dates or very small units of time.

Then there's the range of dates. I'll hazard a guess that the majority of applications don't need to work with dates earlier than those supported by the .NET Framework or the data engine used—1 CE for the .NET Framework, 1753 or 1900 CE for SQL Server, or 100 CE for Microsoft Jet. But it happens. Museums, historians, even antiquarian bookstores might need to store earlier dates.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint