如何使用Ms Access日期/时间扩展数据类型

问题描述:

访问女士文档建议使用名为日期/时间扩展的数据类型:

Ms Access documentation suggests there is a data type called "Date/Time Extended" which:


日期/时间扩展数据类型存储日期和时间信息,类似于日期/时间数据类型,但是它提供了更大的日期范围和更高的分数精度,并与SQL Server datetime2日期类型兼容。

The Date/Time Extended data type stores date and time information and is similar to the Date/Time data type, but it provides a larger date range, a higher fractional precision, and compatibility with the SQL Server datetime2 date type.

但是我不能选择它,因为该选项不在表格设计中下拉列表。

However I cannot select this as the option is not in the table design Data Type drop/down list.

我的版本是Microsoft Access for Microsoft 365(16.0.12827.20328)64位。

My version is Microsoft Access for Microsoft 365 (16.0.12827.20328) 64-Bit.

我如何使用日期/时间扩展数据类型?

How can I use the "Date/Time Extended" data type?

据我所知,日期/时间扩展还没有

As far as I can tell, Date/Time Extended is not yet available in the latest release builds.

文档似乎早于实际版本。

The documentation seems to be ahead of the actual release.

如果无论是否需要它,请转到帐户页,并注册Office Insider(测试版)通道,然后单击更新选项和立即更新。

If you need it regardless, go to the Account page, and sign up for Office Insider, the beta channel, then click update options, and Update Now.

之后,它在字段类型的下拉列表中。请注意,使用它会破坏与Office早期版本的兼容性。

After that, it's in the dropdown for field types. Note that using it will break compatibility with previous versions of Office.

我目前可以使用日期/时间扩展数据类型,并且版本为16.0.13012.20000(最新Beta

I can currently use the Date/Time Extended data type, and am on version 16.0.13012.20000 (latest beta channel).

请注意,我强烈建议您不要将此类型用于测试以外的其他用途,直到在发行版本中使用为止,并且您100%确定每个人都使用您打算在其中使用它的数据库已更新为允许它的版本。

Note that I strongly recommend on refraining from using this type for other purposes than testing until it's in a release version and you're 100% sure everyone using the database you intend to use it in has updated to a version that allows it.