我有一个在server.User中运行的应用程序使用它来自不同的时区。现在我必须节省插入数据的时间。 当用户将数据保存在数据库中我正在做datetime.utcNow()。我认为它将服务器的本地时间(我的应用程序所在的位置)转换为utc时间。我是对的吗? 现在我已经保存了所有用户创建帐户的时区。现在我正在显示他们保存数据的时间(这是在utc的数据库中) )从utc转换到他们当地的时区(从我的帐户中取出他的时区)。 我是否正确?请帮助,实际上如果我是正确的,然后我将这个方法应用于整个项目。
I have an application running in server.User using this are from different time zone.Now I have to save the time of their inserted data. When user save the data in database I am doing datetime.utcNow().I think it converts the local time of server(in which my application is situated) to utc time. Am I right? Now I have saved all users' time zone on creating there account.Now I am showing their time of saved data (which is in database in utc) by converting from utc to their local time zone (from his account I'm fetching his time zone). Am I in right way?please help,actually if I am in right way then I'll apply this approach to the whole project.
推荐答案如果您使用服务器时区作为转换的基础到UTC,这是一个基于网络的产品,然后不,这是不对的。您需要使用用户时区,并对此进行更正 - 他可能与您的服务器处于不同的时区(我是:我住在英国,我的网站服务器位于美国)。 这应该有所帮助: msdn.microsoft /en-us/library/bb882561(v=vs.110).aspx [ ^ ] - 它讨论了解决问题的几种方法。 If you are using the server time zone as the "Base" for your conversion to UTC and this is a web-based product, then no, it's not right. You need to use the user time zone, and correct for that - he may well be in a different time zone from your server (I am: I live in the UK, and my website server is in the USA). This should help: msdn.microsoft/en-us/library/bb882561(v=vs.110).aspx[^] - it discusses a couple of approaches to the problem.
更多推荐
如何在不同时区用户的数据库中保留时间
发布评论