#604 Incorrect DB2 TIMESTAMP in create data script

2.6.4
closed-fixed
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
     

Log in to post a comment.