在Microsoft Access BD中获取服务器日期 [英] Get Server Date in Microsoft Access BD

问题描述

我想问一下是否有某种方法可以从Microsoft Access数据库中获取服务器日期.

我知道Date()和Time()方法，但是在SELECT中它们给了我当地时间.

Hi,
i wanted to ask if there was some way to get the server date from a Microsoft Access database.

I know about Date() and Time() methods, but in SELECT they give me local time. Can you give some help with this?

推荐答案

您是什么意思?您是否正在尝试使用Access数据库检索远程服务器的日期/时间?如果是这样，我认为那是不可能的.

如果您正在本地计算机上运行数据库，并且打算将其部署到服务器上，请不用担心，一旦连接到数据库并执行查询，它将返回服务器数据/时间.

What do you mean? Are you trying to retrieve remote server date/time using Access Database? If so, I don''t think that would be possible.

If you are running the database in your local machine, and you intend to deploy it to the server, don''t worry, it will return you the server data/time once you connect to it and execute the query.

这篇关于在Microsoft Access BD中获取服务器日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！