Results 1 to 7 of 7

Thread: GMT, BST, DST offsets

  1. #1

    Thread Starter
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    GMT, BST, DST offsets

    I'm dealing with a bunch of stock market tick data files, one file per
    trading day, going from 4-Apr-2008 to present. Each file has around
    800,000 records. All timestamps are GMT.

    I am trying to adjust GMT to Eastern Time, USA, and further, need to
    take into account Daylight Savings Time (DST) vs Standard Time (ST)

    Two questions:

    1. Does GMT "change"? (ie, does it change by 1 hour for DST vs ST)

    2. I understand that British Summertime (BST) changes about a week
    differently than DST, but, if GMT is "static" (ie, no changes), then I
    probably don't need to worry about BST vs DST, right?

    Spoo

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: GMT, BST, DST offsets

    My belief was that GMT never changes.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3

    Thread Starter
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    Re: GMT, BST, DST offsets

    I was leaning that way as well, but wasn't sure.

  4. #4
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: GMT, BST, DST offsets

    Quote Originally Posted by GaryMazzone View Post
    My belief was that GMT never changes.
    That's correct. GMT never changes, but England changes to BST during the course of the summer. GMT is the same as UTC, AFAIK.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog

  5. #5
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373

    Re: GMT, BST, DST offsets

    You can probably do this all with .NET timezoneinfo classes.

  6. #6

    Thread Starter
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    Re: GMT, BST, DST offsets

    Quote Originally Posted by kleinma View Post
    You can probably do this all with .NET timezoneinfo classes.
    Thanks for idea, but I'm hoping to do this with VB6 and no classes.
    I can't imagine that it should be too difficult.

    All I need now, I think, is the algorithm for DST and ST.. ie, for 2008 thru
    2010, what date it changes fwd and back (I know it's on a Sunday).

    2008 >> DST, >> ST
    2009 >> DST, >> ST
    2010 >> DST, >> ST

  7. #7

    Thread Starter
    PowerPoster Spoo's Avatar
    Join Date
    Nov 2008
    Location
    Right Coast
    Posts
    2,656

    Re: GMT, BST, DST offsets

    Got this far

    Code:
          Begin DST     End DST
          ---------     -------
    2010  3/14/10       11/7/10 
    2009  3/08/09       11/1/09
    2008  3/09/08       11/2/08
    
               GMT - 5           GMT - 4           GMT - 5
            ---------------   ---------------   ---------------
    2010    Jan-1 to Mar-14   Mar-14 to Nov-7   Nov-7 to Dec-31
    2009    
    2008
    Need those other dates...

    EDIT: Got 'em
    Thanks, guys, for info re GMT.

    EDIT-2: Even better...
    DST beg: 2nd Sunday in Mar
    DST end: 1st Sunday in Nov

    Spoo
    Last edited by Spoo; Apr 16th, 2010 at 10:58 AM. Reason: Got other dates

Posting Permissions

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



Click Here to Expand Forum to Full Width