OK then I figured autonumbers are here to stay, but for things that need to also be date/time stamped, is there any preference for the single DateTime data type vs. the separate Date and Time data types (I'm thinking in terms of storage overhead, query speeds, indexing, ordering, etc.)?
On Wed, Oct 17, 2012 at 11:08 AM, William Stacy <[email protected]>wrote: > Are there any advantages to using one DateTime column over 2 separate > columns of Date and Time? > > Also, I'm wondering if DateTime or Date+Time stamps could be used instead > of autonumbering with it's rules etc.? It seems to me that it would be > rare to have any duplications of DateTime or of Date+Time if time is stored > to milliseconds, unless rows are being added programmatically as opposed to > by key data entry. > > -- > William Stacy, O.D. > > Please visit my website by clicking on : > > www.FolsomEye.com > > > > -- William Stacy, O.D. Please visit my website by clicking on : www.FolsomEye.com
