Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2011
    Posts
    2

    Unanswered: DB2 v815 updating timestamp column adds one hour to string entered

    this is my first time posting so bear with me...

    when I update a DB2 column defined as “timestamp” with any time between 2-3 a.m. on 3/13/2011 (US time change date) an hour is automatically added. However a customer of mine can modify date values in their tables to have times between 2 and 3 on this date without DB2 adding an hour. The hour between 2-3 does not really exist since we jumped forward.

    I am trying to determine where this functionality is set. is it ZPARM setting?

    example:

    update table set TRN_DT = '2011-03-13 02:11:10'

    The statement runs without error but the results are:

    TRN_DT
    2011-03-13 03:11:10

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I would guess you have a timezone set that tells DB2 about the DST shift applicable to that timezone? The customer may have a different timezone set in which the DST shift occurs on another date (or no DST shift at all).
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2011
    Posts
    2
    Thanks Knut, that sounds plausible but what I am wondering is where this is set.

    George

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I would start looking in the system settings.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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