Recent content by Jason King

  1. J

    tzh in compare table data

    Any updates on this?
  2. J

    tzh in compare table data

    I suppose its unfair to bring back a 5 year old post, but since the fix wasn't in 7.1 or 8 or 9 when might we benighted folks from the new world be able to use timestamps with time zones in data compares w/o having to hand fix the data? I'll be happy to provide sample data or whatever would...
  3. J

    tzh in compare table data

    Will this fix be in 7.1? Is there anything I can do to facilitate getting this fix in?
  4. J

    tzh in compare table data

    I'm in the USA where timezone hours are negative. When I do a compare table data on tables w/ timestamp with time zone columns the tzh part comes out as a large negative number. examples: UPDATE DAY_RATES T SET DATE_MODIFIED = TO_TIMESTAMP_TZ('2006/12/04 02:01:10.531000000 250:00', 'YYYY/MM/DD...
Back
Top