Time on Update is exactly 3 hours less than time entered

Discussion in 'ASP .Net Web Services' started by Ray Wood, Jul 17, 2003.

  1. Ray Wood

    Ray Wood Guest

    I am Updating a record on a hosted SQL-S2K. I am using a
    WebService and a stored procedure to do the Update. Two
    of the columns are smalldatetime datatypes of which I only
    need the time. I usually plug in a current date and the
    specific time i want to save. After updating, the time
    recorded is exactly 3 hours less than the time I entered.
    No matter what date/time i put in, the hour is always 3
    less than i entered. I even went as far as entering the
    date/time as a string and casting it inside of the stored
    procedure, even then the hours of the time are always
    three less than entered. Coincedent or not the Web/SQL
    host is in CA and i am on the east coast (3 hours
    difference). I can bypass the WebService and hit the Proc
    directly and it works OK. However I am very confused as
    to why going through the WebService as a string and
    casting inside the SP still causes the problem.
     
    Ray Wood, Jul 17, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. TN Bella
    Replies:
    1
    Views:
    1,502
    TN Bella
    Jul 1, 2004
  2. falcon
    Replies:
    10
    Views:
    18,700
    Roedy Green
    Feb 24, 2006
  3. Rahmi Acar
    Replies:
    0
    Views:
    563
    Rahmi Acar
    Jul 17, 2003
  4. AShopper.net
    Replies:
    0
    Views:
    326
    AShopper.net
    Nov 26, 2007
  5. rutherf
    Replies:
    2
    Views:
    431
    rutherf
    Oct 28, 2006
Loading...

Share This Page