Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#604 Incorrect DB2 TIMESTAMP in create data script

2.6.4
closed-fixed
Rob Manning
5
2008-03-05
2008-01-21
JBernd
No

When I create a data script for a table on DB2
which includes a TIMESTAMP column, the microsecond
part of the timestamp is missing.

Instead of creating a value like:
{ts '2007-08-17 15:57:07.311001'}
it creates:
{ts '2007-08-17 15:57:07.311'}

it seems that is uses milliseconds instead of the
microseconds in DB2.

Discussion

  • Rob Manning
    Rob Manning
    2008-03-05

    Logged In: YES
    user_id=1287991
    Originator: NO

    This is fixed in CVS. Check it in the next snapshot.

    Rob

     
  • Rob Manning
    Rob Manning
    2008-03-05

    • labels: 796188 --> SQL Scripts Plugin
    • milestone: 126228 --> 2.6.4
    • status: open --> closed-fixed