开发者

Is it possible to save year 1 to 99 as date-value in Access database?

开发者 https://www.devze.com 2022-12-13 08:27 出处:网络
Access automatically converts any value under 100. ie: 0099 converts to 1999 and 0010 to 2010 and 0001 to 2001.

Access automatically converts any value under 100. ie: 0099 converts to 1999 and 0010 to 2010 and 0001 to 2001.

Is there any w开发者_开发知识库ay around this problem or is it not possible to save dates in Access so far away?


Access won't let you store dates earlier than 1/1/100 AD.

Of course, you could always just store an integer for the year and do your own date handling.

0

精彩评论

暂无评论...
验证码 换一张
取 消