两台机器上相同标准的数据表结果之间的差异 [英] difference between data table results on same criteria on two machines

问题描述

我正在调用一个返回数据表的存储过程，我将此数据表指定为其网格的数据源。



我的应用程序的前端部署在两台不同的机器上。当我从这些机器获得相同搜索条件的结果时，除了日期时间值之外，我得到的所有值都相同。请查看两台机器的截图。

截图1：



https://s3.amazonaws.com/prod_object_assets/assets/ 61105182513111 / ImagePTCUATRelease.jpg？AWSAccessKeyId = AKIAIXM6FRIC5QVSA63Q&Expires = 1445950530&Signature = pUnDHHYrdEkYv％2FXXPifUCxmi9eI％3D＃_ = _



看看这个。



截图2：



https://s3.amazonaws.com/prod_object_assets/assets/61105182513109/ImagePTCNaumanRelease.jpg?AWSAccessKeyId=AKIAIXM6FRIC5QVSA63Q&Expires= 1445950532&Signature = Dju5BrzT750Lp6％2BTHHr96TX％2BByM％3D＃_ = _





i知道存在某种文化/时差问题，因为这些两台机器在不同国家远程访问。如何在数据库端或应用程序级别（c＃代码）上解决问题。

i am calling a stored procedure that is returning a data-table and i am assigning this data-table as its as data source of my grid.

Front end of my applications is deployed on two different machines . when i get result from these machines on same search criteria , i get all values same except date-time values . please see the screenshots from both machines for clarification.
Screenshot1:

https://s3.amazonaws.com/prod_object_assets/assets/61105182513111/ImagePTCUATRelease.jpg?AWSAccessKeyId=AKIAIXM6FRIC5QVSA63Q&Expires=1445950530&Signature=pUnDHHYrdEkYv%2FXXPifUCxmi9eI%3D#_=_

and look at this.

Screenshot2:

https://s3.amazonaws.com/prod_object_assets/assets/61105182513109/ImagePTCNaumanRelease.jpg?AWSAccessKeyId=AKIAIXM6FRIC5QVSA63Q&Expires=1445950532&Signature=Dju5BrzT750Lp6%2BTHHr96TX%2BByM%3D#_=_


i know there is some kind of culture/ time difference issue because these two machines are in different countries accessed remotely. how can i ressolve the issue either on DB side or on application level(c# code).

推荐答案

您不会选择非常明确地解释您的问题，但我得到的印象是，即使过期时间少于服务器时间，您的问题仍然是由于时间过期而被拒绝访问。



如果是在这种情况下，您唯一的选择是确保您获得全时格式，例如

You don't choose to explain your issue very clear, but I get the impression that your problem is that the you get an access denied due to a time expired even though the expires time is less than the server time.

If that is the case your only option is to make sure you get the full time format, such as

YYYY-MM-DDThh:mm:ss.sTZD

YYYY = four-digit year
    MM   = two-digit month (01=January, etc.)
    DD   = two-digit day of month (01 through 31)
    hh   = two digits of hour (00 through 23) (am/pm NOT allowed)
    mm   = two digits of minute (00 through 59)
    ss   = two digits of second (00 through 59)
    s    = one or more digits representing a decimal fraction of a second
    TZD  = time zone designator (Z or +hh:mm or -hh:mm)

参见 http://www.w3.org/TR/NOTE-datetime [ ^ ]



时区指示符是关键。

See http://www.w3.org/TR/NOTE-datetime[^]

The time zone designator is the key.

这篇关于两台机器上相同标准的数据表结果之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！