Convert DB2 Date to Timestamp

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tgwacker
    New Member
    • Apr 2010
    • 1

    Convert DB2 Date to Timestamp

    I have an existing DB2 table with a date field in it. This field is being changed to a timestamp field. We want to unload the table, add a constant to the date field (-00.00.00.000000 ), then reload it to the redefined table. Is there a means of adding the time to the date during the unload?
Working...