difference between data table results on same criteria on two machines

Question

0.00/5 (No votes)

See more:

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).

Posted 27-Oct-15 3:00am

Member 12042186

Add a Solution

Comments

phil.o 27-Oct-15 9:20am

In what is this an issue? If you absolutely want all values equal, what is the point to get them from source in the first place?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

George Jonsson · Answer 1 · 2015-10-27T04:57:00

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)

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

The time zone designator is the key.