exact time?

Discussion in 'Databases' started by tetridcom00, Aug 2, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. tetridcom00

    tetridcom00

    how can i get exact time with getdate() from your server if a live in venezuela and i have 3 hour diferent?
     
    tetridcom00, Aug 2, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    getdate() will return Pacific standard time (PST)

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Aug 3, 2005
    #2
  3. Scott

    Scott

    Since you know there is a three hour difference you can use:
    DATEADD(hour, +3, GETDATE()).

    However, this will not account for Daylight Savings time which is used on the DASP server.
     
    Scott, Aug 3, 2005
    #3
  4. Scott

    Scott

    Daylight Savings Time is in effect from 2AM on the first Sunday in April until 2AM on the last Sunday in October.
     
    Scott, Aug 22, 2005
    #4
  5. tetridcom00

    tetridcom00

    When changeDaylight Savings time which is used on the DASP server.?
     
    tetridcom00, Aug 22, 2005
    #5
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page