Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2002
    Posts
    23

    Unanswered: datetime compare - eastern and pacific

    Hi,

    I need to compare two datetime values, one is eastern and anther is pacific. Is there an existing function that I can turn a pacific time to eastern one? or I have to write it by myself?

    Thanks,

    Lili
    DTS -> Oracle

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    you might try using the dateadd function to manipulate the time by +2 hours.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Apr 2002
    Posts
    23
    It works! Thank you.

    In case someone wanna know, I used:
    SET @NEWSTART = DATEADD(HH, 3, OLDSTARTTIME)
    DTS -> Oracle

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •